Mysql: compare subquery to multiple values in where statement

If you need to compare multiple columns in your subquery, you can use logical operators within the subquery to combine multiple conditions. Be careful and make sure that the number and data types of columns in the subquery match the columns in the main query.

Source code viewer
SELECT column1, column2, ...
FROM your_table
WHERE (your_subquery_column1, your_subquery_column2) IN (
    SELECT subquery_column1, subquery_column2
    FROM your_subquery
    WHERE condition1 = value1
      AND condition2 = value2
);
Programming Language: MySQL

Browse Tutorials

“Talk is cheap. Show me the code.” ― Linus Torvalds

Mysql: compare subquery to multiple values in where statement

You are here