数据库当前信息为:
将a,b分割开,变成两条数据
SQL:
SELECT a.id,SUBSTRING_INDEX(SUBSTRING_INDEX(a.`name`,',',b.help_topic_id+1),',',-1) as `name`
from a a left join mysql.help_topic b
on b.help_topic_id < (LENGTH(a.`name`)-LENGTH(REPLACE(a.`name`,',',''))+1)
ORDER BY a.id;
SQL是使用了mysql提供的SUBSTRING_INDEX函数