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