SQL multiple columns in IN clause

May 30, 2023 by Tarik

You could do like this:

SELECT city FROM user WHERE (firstName, lastName) IN (('a', 'b'), ('c', 'd'));

The sqlfiddle.