SELECT
SUBSTRING_INDEX(SUBSTRING_INDEX( a.`deliverCodes`, ',', b.help_topic_id + 1 ), ',', - 1) AS deliverCode
FROM
( SELECT '1,2,11,23,45,8,7,6,9,5,4' AS deliverCodes ) AS a
JOIN mysql.help_topic AS b ON b.help_topic_id < ( LENGTH( a.`deliverCodes` ) - LENGTH( REPLACE ( a.`deliverCodes`, ',', '' ) ) + 1 );
解析
1.Substring_index的:取得目标字符串左侧第n个分割符左侧的部分,n为负时返回右侧第n个的右部分
2.help_topic 是数据库mysql的一个表,主要使用表中的序号0-N来进行判断取值