SQL Cheat Sheet/Filter with IN

Match any value from a list.

Section: Filtering Rows

Filter with IN

sql
sql
SELECT *
FROM products
WHERE category IN ('books', 'games', 'toys');
Explanation

IN is often clearer than multiple OR comparisons.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Filtering Rows
Filter with equality
Return rows matching an exact value.
OpenIn sheetsqlsame section
Use comparison operators
Compare numeric or date values.
OpenIn sheetsqlsame section
Filter with BETWEEN
Filter a value within an inclusive range.
OpenIn sheetsqlsame section
Pattern matching with LIKE
Find rows using wildcard patterns.
OpenIn sheetsqlsame section
Test for NULL
Filter rows with missing values.
OpenIn sheetsqlsame section
Select all columns
Return all columns from a table.