SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('1,2,3',',', help_topic_id +1),',',-1)AS num
FROM mysql.help_topic
WHERE help_topic_id < LENGTH('1,2,3')- LENGTH(REPLACE('1,2,3',',',''))+1
2.# 字符串 ‘1,2,3’ 一行变多行 1 2 3,无需使用mysql.help_topic
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('1,2,3',',', n.number),',',-1)AS split_string
FROM(SELECT1AS number
UNIONALLSELECT2UNIONALLSELECT3UNIONALLSELECT4) n
WHERE n.number <=1+(LENGTH('1,2,3')- LENGTH(REPLACE('1,2,3',',','')))/ LENGTH(',')