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;