mysql模糊查询

[哎呦喂哈]

一条sql语句如何模糊查询多个字符串
比如我要把content字段里包含 aaaa、bbb、ccc、dddd 这几个字符串的数据排除掉
应该咋写

[Cactus_hxk]

SELECT * FROM TABLE WHERE content LIKE '%aaaa%' AND content LIKE '%bbb%' AND content LIKE '%ccc%' AND content LIKE '%dddd%'

[眉宇下的小格调]

最笨的方法： select content from A where content not like 'aaaa' and content not like 'bbb' and content not like 'ccc'

[眉宇下的小格调]

引用 2 楼 u010425898 的回复:

最笨的方法： select content from A where content not like 'aaaa' and content not like 'bbb' and content not like 'ccc'

忘了给加%了，补上

[哎呦喂哈]

引用 1 楼 huiwenjie168 的回复:

SELECT * FROM TABLE WHERE content LIKE '%aaaa%' AND content LIKE '%bbb%' AND content LIKE '%ccc%' AND content LIKE '%dddd%'

最起码你用个or不应该用and吧 有简单点的吗，aaa、bbb、ccc是select语句查出来的，不是死的

[豫澜之利]

直接： select * from table where content not like '%aaaa%' orcontent not like '%bbb%' orcontent not like '%ccc%' orcontent not like '%dddd%'; 或者麻烦些： select * from table where id not in (select id from table where content like '%aaaa%' and content like '%bbb%' and content like '%ccc%' and content like '%dddd%');