null
in SQL means ‘unknown’.
This means that the result of using any comparison operator, like =
, with a null
is also ‘unknown’.
To check if a column is NULL
(or not NULL
), use the special syntax of IS NULL
(or IS NOT NULL
) instead of using =
.
Applying that to your statement,
SELECT * FROM table WHERE timestamp IS NULL;
should work.