how to add WHERE clause to Query on android

Question

I would like to limit the results to those whose KEY_HOMEID is equal to journalId. I've been on this for a couple days any help would be appreciated.

public Cursor fetchAllNotes(String journalId) { return mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_HEIGHT, KEY_BODY, KEY_HOMEID},"FROM DATABASE_TABLE WHERE KEY_HOMEID = journalId",null, null, null, null,null); }

score 26 · Accepted Answer · answered Jul 17 '10 at 14:18

26

Have a look at http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#query

Your query should look a little like this:

mDb.query(DATABASE_TABLE, // Table name
          columnNames, // String[] containing your column names
          KEY_HOMEID+" = "+jounalId, // your where statement, you do not include the WHERE or the FROM DATABASE_TABLE parts of the query,
          null,
          null,
          null,
          null
         );

If you feel more comfortable writing sql queries you can also use:

mDb.rawQuery("SQL STATEMENT", null);

answered Jul 17 '10 at 14:18

m6tt

4,223
1
22
20

Thanks. Works. I didnt realize that SQL statment could only be used in rawQUery. – Brian Jul 17 '10 at 15:18
See also my answer on your earlier (pretty much identical) question :) http://stackoverflow.com/questions/3269863/sqlite-and-android-how-do-i-use-string-having-in-my-query/3271769#3271769 – Christopher Orr Jul 17 '10 at 17:43
1

please avoid 'rawQuery' when possible – dev4life Jun 21 '14 at 15:02

score 7 · Answer 2 · answered Aug 06 '14 at 09:38

It makes your code more clear if you'll use it where arguments (in query parameters) Example:

        String [] settingsProjection = {
                DBContract.Settings._ID,
                DBContract.Settings.COLUMN_NAME_USER_ID,
                DBContract.Settings.COLUMN_NAME_AUTO_LOGIN
        };

        String whereClause = DBContract.Settings.COLUMN_NAME_USER_ID+"=?";
        String [] whereArgs = {userId.toString()};

        Cursor c = db.query(
                DBContract.Settings.TABLE_NAME,
                settingsProjection,
                whereClause,
                whereArgs,
                null,
                null,
                null
        );

I couldn't use `userId.toString()` instead I used `Integer.toString(userId)` — Carlo Espino, May 04 '15 at 23:57

score 2 · Answer 3 · answered Mar 18 '12 at 17:58

I was looking for an answer to my problem here as well.

It turned out that I tried to have a String instead of an Integer. My solution was to do it like that: 'String' instead of Integer.

Here is the code that worked for me in the end:

return db.query(TABLE_NAME_REMINDER, PROJECTION, REMINDER_REMINDER_TYPE+" = '"+rem_type+"'", null, null, null, null);

how to add WHERE clause to Query on android

3 Answers3

Linked