mysql 逗号分隔的字段转成列

CREATE TABLE test_name(
    id       int(11)    not null auto_increment,
    names varchar(100)    not null,
PRIMARY KEY(id)
)


insert into test_name values (1,'11,22,33');
insert into test_name values (2,'44,55,66');
insert into test_name values (3,'77,88,99');


SELECT a.id,SUBSTRING_INDEX(SUBSTRING_INDEX(a.names,',',b.help_topic_id+1),',',-1) as name  
from test_name a left join mysql.help_topic b
on b.help_topic_id < (LENGTH(a.names)-LENGTH(REPLACE(a.names,',',''))+1)