Search multiple DB columns with Android Search Dialog

Question

I've got the Android Search Dialog working, but the issue I'm having is that I have a 3 column DB table where I'd like all 3 columns to be searched. The below method only performs a search on Column 1 of the table:

//--- GET RECORDS FOR SEARCH
public Cursor searchDB(String query) {
    String[] allColumns = new String[]{ KEY_COLUMN1, KEY_COLUMN2, KEY_COLUMN3 };
    return db.query(true, DB_TABLE, new String[] { KEY_ROWID,
            KEY_COLUMN1, KEY_COLUMN2, KEY_COLUMN3 }, KEY_COLUMN1 + " LIKE" + "'%"   + query + "%'", null, null, null, null, null);
}
//--- END Get Records for Search

So I tried adding a string array to the query like this:

//--- GET RECORDS FOR SEARCH
public Cursor searchDB(String query) {
    String[] allColumns = new String[]{ KEY_COLUMN1, KEY_COLUMN2, KEY_COLUMN3 };
    return db.query(true, DB_TABLE, new String[] { KEY_ROWID,
            KEY_COLUMN1, KEY_COLUMN2, KEY_COLUMN3 }, allColumns + " LIKE" + "'%"        + query + "%'", null, null, null, null, null);
}
//--- END Get Records for Search

but that crashes the app. So how can the method be modified to search three columns (Column1, Column2, and Column3)?

Barak · Accepted Answer · 2012-05-31 04:32:28Z

6

You can do that like this (assuming you want all rows that match at least one column):

public Cursor searchDB(String query) { 
    return db.query(true, DB_TABLE, new String[] { KEY_ROWID, KEY_COLUMN1, KEY_COLUMN2,
    KEY_COLUMN3 }, KEY_COLUMN1 + " LIKE" + "'%" + query + "%' OR " + KEY_COLUMN2 + 
    " LIKE" + "'%" + query + "%' OR " + KEY_COLUMN3 + " LIKE" + "'%" + query + "%'", 
    null, null, null, null, null); 
}

answered May 31, 2012 at 4:32

Barak

16.4k9 gold badges54 silver badges86 bronze badges

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

Comments

Vishwanath Sungal · Accepted Answer · 2012-05-30 19:49:09Z

0

you need to pass "Null" in place of "allColumns". That will serach all the columns in the row

answered May 30, 2012 at 19:49

Vishwanath Sungal

1311 gold badge1 silver badge8 bronze badges

1 Comment

kirktoon1882 Over a year ago

passing null causes the search to return nothing. But I see where you were going with that....

kosa · Accepted Answer · 2012-05-30 19:49:30Z

0

allColumns + " LIKE" + "'%"        + query + "%'"

I think you need to try something like this

column1 + " LIKE '%' AND "+column2        + " LIKE '%' AND " etc.,

Note: There may be syntax errors. It is hand typed.

answered May 30, 2012 at 19:49

kosa

66.7k15 gold badges134 silver badges170 bronze badges

1 Comment

kirktoon1882 Over a year ago

I'm still trying combos based on your suggestion. The query doesn't like AND though. So I tried KEY_COLUMN1 + KEY_COLUMN2 + KEY_COLUMN3 + " LIKE" + "'%" + query + "%'" and that crashes the app. Still working on it though.....

Collectives™ on Stack Overflow

Search multiple DB columns with Android Search Dialog

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related