mysql数据库中某个字段的数据为分号分割的数据，将该数据拆分成多行

SELECT
count(id) AS counts ,TITLE,
CODE,
chaifen
FROM
(
SELECT
t.CODE,
t.TITLE,
t.ID,
substring_index(
substring_index(
t.CODE,
';',
b.help_topic_id + 1
),
';',
- 1
) AS chaifen
FROM
ude.tableName t
JOIN mysql.help_topic b ON b.help_topic_id < (
LENGTH(t.code) - LENGTH(REPLACE(t.code, ';', '')) + 1
)
) AS newtable 
GROUP BY
chaifen