先上代码
SELECT DISTINCT
substring_index( substring_index( a.parentAsin, ',', b.help_topic_id + 1 ), ',',- 1 ) AS splitedcolumn,
a.*
FROM
taccpbeutracker a
JOIN mysql.help_topic b ON b.help_topic_id < ( length( a.parentAsin ) - length( REPLACE ( a.parentAsin, ',', '' ) ) + 1 )
AND parentAsin = 'B07CTF5HXH, B06ZYRWCTN'
参考blog:https://blog.csdn.net/pjymyself/article/details/81668157