android sqlite query with multiple where

Question

Here's my current sqlite code:

Cursor c = sqlDatabase.rawQuery("select docid as _id, recipeID from " + TABLE_RECIPE_NAME + 
                " where " + KEY_ownerID + " = ? ", new String[] { ownerID});

It works fine, but when I tried adding multiple where to something like this:

Cursor c = sqlDatabase.rawQuery("select docid as _id, recipeID from " + TABLE_RECIPE_NAME + 
                " where " + KEY_ownerID + " = ?, " + KEY_partnerID + " = ?, " + KEY_advertiserID + " = ?, " + KEY_chefID + " = ?", new String[] { ownerID, partnerID, advertiserID, chefID });

It returns an error. So how do I deal with multiple ?

score 47 · Accepted Answer · edited Dec 21 '17 at 08:33

47

change query to:

Cursor c = sqlDatabase.rawQuery("select docid as _id, recipeID from " +
TABLE_RECIPE_NAME + " where " + KEY_ownerID + " = ? AND " + KEY_partnerID +
" = ? AND  " + KEY_advertiserID + " = ? AND " + KEY_chefID + " = ?",
new String[] { ownerID, partnerID, advertiserID, chefID });

edited Dec 21 '17 at 08:33

Chaitanya

647
10
22

answered Jan 30 '12 at 09:01

jeet

28,501
6
50
52

1

and what if we are looking same field with three similarity? – Samir Dec 17 '18 at 11:41

score 6 · Answer 2 · answered Oct 24 '16 at 12:14

6

You are doing correct but just need to use AND or OR keyword between each where condition as per your requirement. So try using this once.

answered Oct 24 '16 at 12:14

Kailas Bhakade

1,852
22
26

score 2 · Answer 3 · answered Jan 30 '12 at 09:10

2

Probably you have to use AND. You want a query that should return the value in Cursor populated with comparing multiple values. So, you just need to use AND. Instead of using a comma(,). Above answer seems correct but it just lacks the explanation.

answered Jan 30 '12 at 09:10

Lalit Poptani

66,608
21
157
241

score 1 · Answer 4 · answered Oct 24 '16 at 05:41

Use AND and OR for multiple WHERE clauses. Use parentheses if logical grouping or order is needed.

SELECT *
FROM employees
WHERE (last_name = 'Smith' AND first_name = 'Jane') OR (employee_id = 1);

(source)

Note

This supplemental answer omits the Android code formatting because it makes the SQL hard to read and understand. The reader can do their own formatting.

android sqlite query with multiple where

4 Answers4

Linked