php - 如何使用数组中的值通过2行比较来选择mysql中的表？

Question

我有一个像这样的选择查询:

SELECT * FROM `table` 
WHERE `is_deleted`!='1'  AND 
(
 (`a`='1' AND `b`='1') 
  OR 
 (`a`='2' AND `b`='2')
) 
ORDER by `timestamp` DESC LIMIT 0,20

如何使用“IN”运算符与比较行a和b进行选择查询？

Answer 1

您还可以同时使用 in 来处理多个字段。

SELECT * FROM `table` 
WHERE `is_deleted`!='1' 
    AND (`a`, `b`) IN ((1,1),(2,2))
ORDER by `timestamp` DESC LIMIT 0,20

很奇怪，文档IN中没有对这种行为的描述，仅在评论中注明一点。

The IN operator also works with tuples, at least in version 4.1: mysql> select (3,4) in ((2,3),(3,4));