mysql - SQL 高级 where - 合并查询中的两个 where 选择

Question

我想用一个查询在我的数据库中选择两个不同的组:

像这样:

SELECT * FROM RECORDS

WHERE DATE = 'Monday' AND plan = "Weekly"

WHERE DATE = 'Wednesday' AND plan = "Daily"

我可以在单个查询中合并这两个(或更多)“wheres”吗？怎么办？

我希望我说得足够清楚:)

Answer 1

你在追求:

SELECT r.* 
FROM RECORDS r
WHERE (r.DATE = 'Monday' AND r.plan = "Weekly") OR 
      (r.DATE = 'Wednesday' AND r.plan = "Daily")