WHERE

Applies to: sql

WHERE filters rows before they are returned or aggregated, keeping only those matching a condition. Combine conditions with AND/OR and match patterns with LIKE.

SELECT * FROM orders
WHERE status = 'paid' AND total > 100;

See also: select, join