mysql把一条数据根据逗号公拆成多条记录
https://blog.csdn.net/HouJi1/article/details/83652230
SELECT a.id,
SUBSTRING_INDEX(SUBSTRING_INDEX(a.name, ',', b.help_topic_id + 1), ',', - 1 ) NAME
FROM test1 a
JOIN mysql.help_topic b
ON b....
转载
2019-01-10 23:42:00 ·
1739 阅读 ·
0 评论