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 ?

Chaitanya · Accepted Answer · 2017-12-21 08:33:28Z

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, 2017 at 8:33

Chaitanya

7299 silver badges25 bronze badges

answered Jan 30, 2012 at 9:01

jeet

29.2k6 gold badges55 silver badges54 bronze badges

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

1 Comment

Samir Over a year ago

and what if we are looking same field with three similarity?

Kailas Bhakade · Accepted Answer · 2016-10-24 12:14:11Z

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, 2016 at 12:14

Kailas Bhakade

1,92223 silver badges27 bronze badges

Comments

Suragch · Accepted Answer · 2016-10-24 05:41:06Z

3

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.

answered Oct 24, 2016 at 5:41

Suragch

516k340 gold badges1.4k silver badges1.4k bronze badges

Comments

Lalit Poptani · Accepted Answer · 2012-01-30 09:10:09Z

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, 2012 at 9:10

Lalit Poptani

67.3k23 gold badges165 silver badges248 bronze badges

Collectives™ on Stack Overflow

android sqlite query with multiple where

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related