你的需求是列转行,不是行转列 行专列可以用group_concat() select id,group_concat(names) from tb列转行 case when
辅助有LSB1,字段ID,内容1-10000,假设分隔符为* SELECT *,SUBSTRING_INDEX( SUBSTRING_INDEX(a1.SUBJECT,'*',b.id),'*',-1) FROM a a1 LEFT JOIN lsb1 b ON (LENGTH(a1.SUBJECT)-LENGTH(REPLACE(a1.SUBJECT,'*','')))+1>=b.id;
行专列可以用group_concat()
select id,group_concat(names) from tb列转行
case when
SELECT *,SUBSTRING_INDEX(
SUBSTRING_INDEX(a1.SUBJECT,'*',b.id),'*',-1)
FROM a a1 LEFT JOIN lsb1 b
ON (LENGTH(a1.SUBJECT)-LENGTH(REPLACE(a1.SUBJECT,'*','')))+1>=b.id;