一个 mysql 查询问题

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 4177 days ago, the information mentioned may be changed or developed.

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

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

字符串

字段

SQL

3 replies • 2014-11-24 18:57:23 +08:00

huigeer

Nov 24, 2014

mysql 正则

tabris17

Nov 24, 2014

多次查询

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

Nov 24, 2014

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