Stack Exchange
Multiple Columns in an “in” statement (mysql)
Can you please advise how i can implement this sql query:
select * from products where (category, category2, category3) in (2, 138, 136, 125)

Error:
#1241 - Operand should contain 3 column(s)


Simply write all columns in where clause like this:
SELECT *
FROM products
WHERE
  category IN (2, 138, 136, 125) OR
  category2 IN (2, 138, 136, 125) OR
  category3 IN (2, 138, 136, 125)


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


Mmm, is this what you intended to do? 
select * from products where category in (2, 138, 136, 125)
                         AND category2 in (2, 138, 136, 125)
                         AND category3 in (2, 138, 136, 125)

Or with OR , depends on the requirement .
