一个sql很多个not like的简化语句
(2013-01-30 11:02:11)| 分类: MySql |
如:
select * from table where `zongbu` not like '%北京%' and `zongbu` not like '%上海%' and `zongbu` not like '%深圳%' and `zongbu` not like '天津' and `zongbu` not like '香港' and `zongbu` not like '沈阳'
SELECT * FROM table WHERE zongbu NOT REGEXP '北京|上海|深圳|天津|香港|沈阳';
select * from table where `zongbu` not like '%北京%' and `zongbu` not like '%上海%' and `zongbu` not like '%深圳%' and `zongbu` not like '天津' and `zongbu` not like '香港' and `zongbu` not like '沈阳'
SELECT * FROM table WHERE zongbu NOT REGEXP '北京|上海|深圳|天津|香港|沈阳';

加载中…