mysql - 在 MySQL 中合并两个具有不同 WHERE 的 SELECT

Question

有没有办法合并这两个查询？

SELECT * FROM OFF WHERE New = 0 AND Saw = 1 AND El = 0
SELECT * FROM OFF WHERE New = 1 AND Saw = 0 AND El = 0

如果我使用此查询:

SELECT * FROM OFF WHERE New = 0 AND Saw = 1 AND El = 0 AND New = 1 AND Saw = 0 AND El = 0

我显然有其他预期的结果。

谢谢!

Answer 1

对这些条件进行分组时使用OR，

SELECT * 
FROM   `OFF`
WHERE  (New = 0 AND Saw = 1 AND El = 0) OR 
       (New = 1 AND Saw = 0 AND El = 0)