一个 mysql 查询问题

[hellohacker]

某个表中的某个字段存储的数据形式为
demo
10,15,20
------
20,21,23,
------
30,35,40

现在有个字符串如：15,21,35,可以匹配到上面三条记录，因为三条记录中分别含有15 21 35
求sql

[huigeer]

mysql 正则

[tabris17]

多次查询

select * from tab1 where demo like '15,%'
select * from tab1 where demo like '%,15,%'
select * from tab1 where demo like '%,15'
select * from tab1 where demo like '21,%'
select * from tab1 where demo like '%,21,%'
select * from tab1 where demo like '%,21'
select * from tab1 where demo like '35,%'
select * from tab1 where demo like '%,35,%'
select * from tab1 where demo like '%,35'

[wdd2007]

SELECT * FROM table WHERE FIND_IN_SET(15,demo) OR FIND_IN_SET(21,demo) OR FIND_IN_SET(35,demo);