SQL multiple columns in IN clause July 27, 2022 by Tarik You could do like this: SELECT city FROM user WHERE (firstName, lastName) IN (('a', 'b'), ('c', 'd')); The sqlfiddle.