mysql - 如何从mysql表中选择消息

Question

我的 mysql 表中有两个字段 from_id 和 to_id

SELECT * FROM `messages` 
WHERE (`from_id` = $user1_id AND `to_id` = $user2_id) OR 
      (`from_id` = $user2_id AND `to_id` = $user1_id)

但这有点奇怪，有没有办法让查询更加高贵？

就像我想要我发送的所有消息以及那些发送给我的消息

Answer 1

你可以使用UNION ALL:

SELECT * 
FROM `messages` 
WHERE `from_id` = $user1_id AND `to_id` = $user2_id
UNION ALL
SELECT *
FROM `messages`
WHERE `from_id` = $user2_id AND `to_id` = $user1_id;

或者:

SELECT * 
FROM messages
WHERE (`from_id`, `to_id`) IN (($user1_id,$user2_id),($user2_id,$user1_id))