SQLite select where empty?

sql sqlite select isnullorempty
Timo Huovinen picture Timo Huovinen · Sep 1, 2010 · Viewed 133.6k times · Source

In SQLite, how can I select records where some_column is empty?
Empty counts as both NULL and "".

Answer

Guffa picture Guffa · Sep 1, 2010

There are several ways, like:

where some_column is null or some_column = ''

or

where ifnull(some_column, '') = ''

or

where coalesce(some_column, '') = ''

of

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

Related questions

sql, order by column A and then by column B

How to write the sql so that the result can be ordered first by column A than by column B. Something like below: SELECT * FROM tbl WHERE predictor ORDER by col_A and ORDER by col_B

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More
How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More