mysql 字段分割

SELECT

a,SUBSTRING_INDEX(SUBSTRING_INDEX(b,',',help_topic_id+1),',',-1)

AS

num

FROM

mysql.help_topic

,t

WHERE

help_topic_id

<

LENGTH(b)-LENGTH(REPLACE(b,',',''))+1

order

by

num

结果完全就是你要的

$arr = explode(',',$result['id'])

这样$arr数组就是

$arr[0]='a'

$arr[1] ='b'

$arr[2] ='c'