SELECT
a.字段名 B,
substring_index( substring_index( a.col, ',', b.help_topic_id + 1 ), ',',- 1 )
FROM
(
SELECT REPLACE
( REPLACE ( REPLACE ( `字段名A`, '"', '' ), '[', '' ), ']', '' ) AS col,
字段名 B
FROM
表名
WHERE
条件 IS NOT NULL
LIMIT 1
) AS a
JOIN mysql.help_topic AS b ON b.help_topic_id < (
char_length( a.col ) - char_length(
REPLACE ( a.col, ',', '' ))+ 1)
示例:
执行后: