skip to today's puzzle

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

idcomment
101NULL
104NULL

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