mysql - “in” 语句中的多个列 (mysql)

Question

你能告诉我如何实现这个sql查询吗:

select * from products where (category, category2, category3) in (2, 138, 136, 125)

错误:

#1241 - Operand should contain 3 column(s)

Answer 1

只需像这样在 where 子句中写入所有列:

SELECT *
FROM products
WHERE
  category IN (2, 138, 136, 125) OR
  category2 IN (2, 138, 136, 125) OR
  category3 IN (2, 138, 136, 125)