比较复杂:
SELECT GROUP_CONCAT(bb1.ss2 SEPARATOR ',') FROM (
SELECT CONCAT(',',a.link,',') AS aa,
REPLACE(MID(CONCAT(',',a.link,','),b.id,INSTR(MID(CONCAT(a.link,','),b.id,LENGTH(CONCAT(a.link,','))),',')+1),',','')
AS ss2,b.id
FROM tty2 a LEFT JOIN lsb1 b ON LENGTH(a.link)+2>=b.id
WHERE a.status=0 AND MID(CONCAT(',',a.link,','),b.id,1)=','
ORDER BY aa) bb
LEFT JOIN
(SELECT CONCAT(',',a.link,',') AS aa,
REPLACE(MID(CONCAT(',',a.link,','),b.id,INSTR(MID(CONCAT(a.link,','),b.id,LENGTH(CONCAT(a.link,','))),',')+1),',','')
AS ss2,b.id
FROM tty2 a LEFT JOIN lsb1 b ON LENGTH(a.link)+2>=b.id
WHERE a.status=0 AND MID(CONCAT(',',a.link,','),b.id,1)=','
ORDER BY aa) bb1
ON bb1.id>bb.id AND bb1.aa=bb.aa
WHERE bb.ss2='40'
LSB1:字段ID,内容1-10000
你可以将
SELECT CONCAT(',',a.link,',') AS aa,
REPLACE(MID(CONCAT(',',a.link,','),b.id,INSTR(MID(CONCAT(a.link,','),b.id,LENGTH(CONCAT(a.link,','))),',')+1),',','')
AS ss2,b.id
FROM tty2 a LEFT JOIN lsb1 b ON LENGTH(a.link)+2>=b.id
WHERE a.status=0 AND MID(CONCAT(',',a.link,','),b.id,1)=','
ORDER BY aa
生成VIEW