select distinct substring_index(substring_index(a.video_id,',',b.help_topic_id+1),',',-1)
as videoId
from
table a
join mysql.help_topic b
on b.help_topic_id < (length(a.video_id) - length(replace(a.video_id,',',''))+1)
where a.panels_id=91
拆分为:
distinct:去重复操作
a.value:表别名.需要拆分的字段名
table a:表名 别名
help_topic:自增长表