SQL where in 语句顺序问题

你的语句有问题应该这样

select

id

,

name

from

test

where

id

in('1001','1005','1003')

如果你想按顺序的话

这样就可以

select

id

,

name

from

test

where

id='1001'

union

all

select

id

,

name

from

test

where

id='1005'

union

all

select

id

,

name

from

test

where

id='1003'

SELECT t1.a,

(SELECT group_concat(name) FROM t2 WHERE id IN ( 1,2,3 ) ) AS t2n1,

(SELECT group_concat(name) FROM t2 WHERE FIND_IN_SET(id ,t1.a) ) AS t2n2

FROM t1 WHERE t1.id=1

---