In SQLite you can't retrieve a row by testing the equality of a column with NULL.

This doesn't do what you think.

SELECT * from table WHERE column = NULL;

You need to use IS NULL.

SELECT * from table WHERE column IS NULL;

Happy now.