sqlsqliteselectisnullorempty

SQLite select where empty?

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

Solution

  • 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