建立LSB1,字段ID,内容1-10000
SELECT GROUP_CONCAT(ss) FROM (
SELECT *,SUBSTRING_INDEX(
SUBSTRING_INDEX(a1.SUBJECT,',',b.id),',',-1) AS ss
FROM (SELECT '72,172,51725,72,72,72,90' AS SUBJECT) a1 LEFT JOIN zz.lsb1 b
ON (LENGTH(a1.SUBJECT)-LENGTH(REPLACE(a1.SUBJECT,',','')))+1>=b.id) aa
WHERE ss<>'72'
;
示例:
SET @a=',72,172,72,51725,72,90,72,';
SET @b=REPLACE(RTRIM(LTRIM(REPLACE(@a,',72,',' '))),' ',',');
SET @c=IF(RIGHT(@b,1)=',',LEFT(@b,LENGTH(@b)-1),@b);
SELECT @c;