An empty cell is called NULL
NULL means the database has no value there — not zero, not an empty word, just nothing recorded. Because there's nothing to compare, = doesn't work on it. You write IS NULL to find the empty cells, or IS NOT NULL to skip them.
A tiny example
In plain English: Show me the reviews that have no comment recorded.
SELECT id, comment
FROM reviews
WHERE comment IS NULL;Query result
| id | comment |
|---|---|
| 101 | NULL |
| 104 | NULL |
Reviews 101 and 104 are the only reviews with nothing recorded in the comment column.
Related SQL lessons
Ready for a break?
A fresh, bite-sized SQL puzzle waits every morning. Tap tiles, see real results. No terminal, no setup, no timers.
Try today's free SQL puzzle