Mysql 按逗号拆分

1、建测试表

create table table_to_split (
    `id` int unsigned auto_increment primary key,
    `name_list` VARCHAR(64) 
);

2、插入测试数据

insert into table_to_split (id, name_list) values 
(1, 'name01,name02'), 
(2, 'name03,name04,name05');

3、查询

select * from table_to_split;

4、将 name_list 拆分为多行

select 
a.*,
SUBSTRING_INDEX(SUBSTRING_INDEX(a.name_list, ',', h.help_topic_id + 1 ), ',', -1) as name
from table_to_split as a
join mysql.help_topic as h
on h.help_topic_id < ((length(a.name_list) - length(replace(a.name_list, ',', '')) + 1));