SQLite select where empty?

Question

In SQLite, how can I select records where some_column is empty?

Empty counts as both NULL and "".

Answer 1

In SQLite, there are several ways to select records where some_column is empty like this:

where some_column is null or some_column = ''

Otherwise, you can use this:

where ifnull(some_column, '') = ''

Or else you can use the below query:

where coalesce(some_column, '') = ''

Or use this query:

where ifnull(length(some_column), 0) = 0