mysql - 2 where条件一个SQL语句

Question

我想获取该 SQL 行：

SELECT aa.*
FROM Answers AS aa
WHERE event_id = 1 AND
      ( (aa.form_item_id = 1 AND form_item_reply = "John") AND
        (aa.form_item_id = 2 AND form_item_reply = "Doe")
      )
ORDER BY aa.id DESC

但它给出了错误的结果，我想获取它(aa.form_item_id = 1 AND form_item_reply = "John")和(aa.form_item_id = 2 AND form_item_reply = "Doe").

它必须给我以上2个条件结果。

标签： mysqlsql

Answer 1

您可以使用或

SELECT aa.* FROM Answers AS aa WHERE event_id = 1 AND 
( 
(aa.form_item_id = 1 AND form_item_reply = "John") 
OR (aa.form_item_id = 2 AND form_item_reply = "Doe") 
) ORDER BY aa.id DESC