mysql - sql除了like查询

Question

我想要搜索文章:

SELECT *
FROM articles
WHERE `body` LIKE `%src="http://%"

但我想要除了:

src="//example.com"
src="//media.example.com"

我试试这个:

SELECT *
FROM `articles`
WHERE `body` LIKE '%src="http://%' AND
      `body` NOT LIKE '%src="http://example.com%' AND
      `date_show` >= '2018-06-24'
LIMIT 20

但是我得到了错误的结果。我怎样才能正确地做到这一点？

Answer 1

SELECT * FROM `articles` WHERE `body` LIKE '%src="http://%' 
and  `body`  not in (SELECT body
FROM `articles` where `body` NOT LIKE '%src="http://example.com%' )  AND
      `date_show` >= '2018-06-24' LIMIT 20;