原始数据
处理后
sql
SELECT a.id
, a.NAME
, substring_index(substring_index(a.shareholder, ',', b.help_topic_id + 1), ',', - 1) AS shareholder
FROM company a
INNER JOIN mysql.help_topic b
ON b.help_topic_id < (length(a.shareholder) - length(REPLACE(a.shareholder, ',', '')) + 1)
https://developer.aliyun.com/article/1135130
标签：topic,help,index,转化,行列,substring,shareholder,id From： https://www.cnblogs.com/chenqianguan/p/17868076.html