MySQL SELECT IN 带子查询

Question

好吧，所以我遇到了以下问题..我正在尝试使用两个子查询执行单个选择语句。我需要它做的几乎是以下内容..

SELECT * FROM messages WHERE 满足以下条件。

条件1:

 SELECT id 
 FROM messages 
 WHERE `receiver` = 123510 && sender= 123457 && status != 3;

条件2:

 SELECT id 
 FROM messages 
 WHERE receiver = 123457 && sender = 123510 && status !=4;

我尝试执行以下操作:

SELECT * 
FROM messages 
WHERE id IN (
                 (
                     SELECT id 
                     FROM messages 
                     WHERE `receiver` = 123510 && sender= 123457 && status != 3
                 ),
                 (
                     SELECT id 
                     FROM messages 
                     WHERE receiver = 123457 && sender = 123510 && status !=4)
                  )  

但是当我这样做时，mysql 返回子查询返回超过 1 行...

关于如何解决这个问题有什么建议吗？

Answer 1

我认为这就是您正在寻找的:

SELECT *
FROM messages
WHERE (receiver = 123510 AND sender = 123457 AND status <> 3) OR
      (receiver = 123457 AND sender = 123510 AND status <> 4);