FIND YOUR NEXT FEW LINES
The snippet library.
Small, practical examples. Search by task or narrow things down below.
5 snippets foundClear filters
Filter rows with WHERE
Keep products below a chosen price.
WHERE✓ Tested
List distinct values
Remove duplicate category values from a result.
DISTINCT✓ Tested
Match one of several values
Use IN to avoid repeating equality conditions.
IN✓ Tested
Select an inclusive range
Find rows with values between two endpoints.
BETWEEN✓ Tested
Select specific columns
Read only the fields a result needs.
SELECT✓ Tested