Android SQLite query where column is not null and not empty

Question

I cannot figure out the syntax for the .query call. I need to select all records that match a certain column that do not have a null or empty value for a second (different) column

my best attempt:

Cursor cursor = mDatabase.query(DatabaseOpenHelper.TABLE_ROOMS, mAllColumns,
    DatabaseOpenHelper.KEY_ROOM_HOSPITAL_ID
    + " =? AND " + DatabaseOpenHelper.KEY_ISO + " IS NOT NULL OR NOT ?",
    new String[]{String.valueOf(hospitalId), ""}, null, null, null);

This is returning ALL records. If I use AND in place of OR, it returns records matching hospitalId, but ignores the NOT NULL OR NOT "" part.

Any tips? Should I use a rawQuery call?

Koopakiller · Accepted Answer · 2017-08-29 11:54:43Z

72

I believe the correct syntax would be:

AND key IS NOT NULL AND key != ""

where key is your column

edited Aug 29, 2017 at 11:54

Koopakiller

2,8813 gold badges34 silver badges50 bronze badges

answered Jul 12, 2015 at 22:15

BladeCoder

13k3 gold badges61 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hugo Matilla · Accepted Answer · 2019-06-05 16:33:38Z

6

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," ") != ""

answered Jun 5, 2019 at 16:33

Hugo Matilla

1,2842 gold badges13 silver badges15 bronze badges

1 Comment

vonWippersnap Over a year ago

Or even TRIM(column_name) since space is used as the trim character by default.

Collectives™ on Stack Overflow

Android SQLite query where column is not null and not empty

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related