mysql - 如何编写包含多个 LIKE 子句的查询？

Question

我对这个查询有疑问:

SELECT * 
FROM posts 
WHERE title LIKE '%samsung%' 
OR title LIKE '%42%' 
AND price >= '100' 
AND price <= '1000000' 
AND shipping = '1' 
AND sale_type = '1' 
LIMIT 0,50

问题是，当我运行带有 2 个或更多 title LIKE '%%' 的查询时，它只显示带有 title LIKE '%%' 的查询

SELECT * 
FROM posts 
WHERE title LIKE '%samsung%' 
AND price >= '100' 
AND price <= '1000000' 
AND shipping = '1' 
AND sale_type = '1'
LIMIT 0,50

忽略其他选项。但是，如果我只使用标题 LIKE '%%' 运行查询，它就完美无缺。

Answer 1

你可以这样试试:

WHERE title REGEXP 'samsung|42'

更多信息在这里:http://forums.mysql.com/read.php?10,392332,392950#msg-392950