Sharper filters · Patterns and NULL
Fuzzy text, missing values
LIKE matches text patterns: % stands for any run of characters, _ for exactly one. 'B%' means “starts with B”.
NULL means a value is unknown. Nothing equals NULL — not even NULL — so use IS NULL and IS NOT NULL.
Go deeper: NULL in SQL
Try it
SELECT name, breed FROM pets WHERE breed IS NULL;
Press Enter to continue