求大神解答 MySQL 数据库存储的是带有逗号的字段，查出来之后怎么分隔

[文刀一撇]

列如 字段是 小明,小红

我要获取的是
ID name
1 小明
1 小红

[道玄希言]

SET @b = '小明,小红'; SET @a = REPLACE(@b,',', ' union all select '); SET @a = CONCAT('select ', @a); PREPARE rc FROM @a; EXECUTE rc;

[文刀一撇]

这个是MySQL 的语法?看不懂

[chenlianghaodai]

mysql> select id,substring_index(name,",",1) name from xm union all select id,reverse(substring_index(reverse(name),",",1)) name from xm; +------+--------+ | id | name | +------+--------+ | 1 | 小明 | | 1 | 小红 | +------+--------+ 2 rows in set (0.00 sec)