How to formulate a query involving arrays?

Question

MySQL

The query is:
Select all records with columns PRODUCT ID, STORE ID and RESIDUE from the STOCK table where PRODUCT ID and STORE ID match the pairs from the array [ [1, 4], [2,10], [1,2], [5,1] ] .
How to formulate such a query in SQL?

Answer 1

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

Answer 2

via union all