没有仔细看我的代码吗
SELECT * FROM (
SELECT NAME,GROUP_CONCAT(RIGHT(CONCAT('00000',NZ),5) ORDER BY id SEPARATOR '' ) AS NA FROM (
SELECT A1.name,b.`id`,SUBSTRING_INDEX(SUBSTRING_INDEX(a1.NAME,',',b.id),',……
[/Quote]
没有仔细看我的代码吗
SELECT * FROM (
SELECT NAME,GROUP_CONCAT(RIGHT(CONCAT('00000',NZ),5) ORDER BY id SEPARATOR '' ) AS NA FROM (
SELECT A1.name,b.`id`,SUBSTRING_INDEX(SUBSTRING_INDEX(a1.NAME,',',b.id),',',-1) AS NZ
FROM `pre_test` a1 LEFT JOIN lsb1 b ON
(LENGTH(a1.NAME)-LENGTH(REPLACE(a1.NAME,',','')))+1>=b.id ORDER BY A1.ID,B.ID) f
GROUP BY NAME) f ORDER BY na,NAME
SELECT * FROM (
SELECT NAME,GROUP_CONCAT(RIGHT(CONCAT('00000',NZ),5) ORDER BY id SEPARATOR '' ) AS NA FROM (
SELECT A1.name,b.`id`,SUBSTRING_INDEX(SUBSTRING_INDEX(a1.NAME,',',b.id),',',-1) AS NZ
……
[/Quote]
SELECT * FROM (
SELECT NAME,GROUP_CONCAT(RIGHT(CONCAT('00000',NZ),5) ORDER BY id SEPARATOR '' ) AS NA FROM (
SELECT A1.name,b.`id`,SUBSTRING_INDEX(SUBSTRING_INDEX(a1.NAME,',',b.id),',',-1) AS NZ
FROM `pre_test` a1 LEFT JOIN lsb1 b ON
(LENGTH(a1.NAME)-LENGTH(REPLACE(a1.NAME,',','')))+1>=b.id ORDER BY A1.ID,B.ID) f
GROUP BY NAME) f ORDER BY na,NAME