Android SQLite query where column is not null and not empty
I believe the correct syntax would be:
AND key IS NOT NULL AND key != ""
where key
is your column
If multiple spaces can be in your column and you also want to treat them as empty values use TRIM
column_name IS NOT NULL AND TRIM(column_name," ") != ""