Filtering with WHERE
1 min read
The WHERE Clause
WHERE filters rows by a condition.
SELECT * FROM products
WHERE price < 100;
Combining conditions
SELECT * FROM products
WHERE price < 100 AND stock > 0;
Common operators: =, !=, <, >, <=, >=, LIKE, IN, BETWEEN.