The WHERE clause filters records based on specified conditions. Learn how to use WHERE to retrieve exactly the data you need.

Basic WHERE Syntax

SELECT * FROM table_name WHERE condition;

Comparison Operators

SELECT * FROM products WHERE price > 100;

SELECT * FROM products WHERE price <= 50;

SELECT * FROM products WHERE category != 'Electronics';

Multiple Conditions with AND/OR

SELECT * FROM customers

WHERE country = 'USA' AND status = 'active';

SELECT * FROM products

WHERE category = 'Books' OR category = 'Music';

WHERE with IN

SELECT * FROM orders WHERE status IN ('pending', 'processing', 'shipped');

WHERE with BETWEEN

SELECT * FROM products WHERE price BETWEEN 10 AND 100;

WHERE with LIKE

SELECT * FROM customers WHERE email LIKE '%@gmail.com';

Generate WHERE Clauses Automatically

Describe your filter in plain English and let AI2sql write the perfect WHERE clause.