1
huigeer 2014-11-24 18:42:17 +08:00
mysql 正则
|
2
tabris17 2014-11-24 18:53:42 +08:00
多次查询
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' |
3
wdd2007 2014-11-24 18:57:23 +08:00 1
SELECT * FROM table WHERE FIND_IN_SET(15,demo) OR FIND_IN_SET(21,demo) OR FIND_IN_SET(35,demo);
|