SELECT a.dev_id,SUBSTRING_INDEX(SUBSTRING_INDEX(a.stage,',',b.help_topic_id+1),',',-1)
FROM
my_table a
JOIN
mysql.help_topic b
ON b.help_topic_id < (LENGTH(a.stage) - LENGTH(REPLACE(a.stage,',',''))+1)
ORDER BY a.dev_id;
mysql一个字段用逗号分隔,转化为多行
最新推荐文章于 2024-03-08 14:03:33 发布