mysql - 我可以缩短这个 mysql 查询吗？

Question

我在脚本中使用此查询:

SELECT *
FROM `login_messages`
WHERE  `user_id` = :user_id
      AND `to` = :to
      AND (`date` BETWEEN :date AND NOW())
   OR     `user_id` = :to
      AND `to` = :user_id
      AND (`date` BETWEEN :date AND NOW())
ORDER BY `login_messages`.`date` ASC

有没有办法使用这个部分

(
    AND (`date` BETWEEN :date AND NOW())
)

仅查询一次？这对于查询加载速度并不重要？

谢谢大家。

Answer 1

您可以使用IN子句

试试这个

SELECT *
FROM login_messages
WHERE ((user_id ='userid1' AND TO ='to1')
    OR (user_id ='to1' AND TO ='userid1'))
  AND (`date` BETWEEN :date AND NOW())
ORDER BY `login_messages`.`date` ASC