CODEWITHSUNDEEP
androidmysqlsqlite
Waz
Waz

Reputation: 161

SQLiteDatabase - How to use where clause?

public Cursor fetchTimetable() {
    return mDb.query(DATABASE_TABLE_TIMETABLE, new String[] {TIMETABLE_ROWID,    TIMETABLE_MODULECODE, TIMETABLE_MODULENAME, TIMETABLE_ROOM, TIMETABLE_LECTURER, TIMETABLE_TIME}, null, null, null, null, null);
}

For example if i wanted TIMETABLE_MODULECODE = 123. How would i do this, i have read its the first null. I have tried this below but still doesnt work

public Cursor fetchTimetable() {
    String a = "TIMETABLE_CODE = ADD";
    return mDb.query(DATABASE_TABLE_TIMETABLE, new String[] {TIMETABLE_ROWID, TIMETABLE_MODULECODE, TIMETABLE_MODULENAME, TIMETABLE_ROOM, TIMETABLE_LECTURER, TIMETABLE_TIME}, a, null, null, null, null);
}

Upvotes: 8

Views: 36817

Answers (7)

Wachaga Mwaura
Wachaga Mwaura

Reputation: 3600

If you're checking against a string value you'll want to wrap the string in quotes like below:

dbHelper.COL_EMAIL +"='"+givenEmail+"'",

Upvotes: 1

lalit
lalit

Reputation: 41

the right syntax is 

String[] projection= {column names};
String[] where={"values for where clause"}; //this must be array     
public Cursor fetchTimetable() { 

    return mDb.query(TABLE_NAME, projrction, "columname"+"=?", where, null, null, null); 
}

Upvotes: 4

Syed Danish Haider
Syed Danish Haider

Reputation: 1384

You can use Use this query:

SQLiteDatabase db = this.getReadableDatabase();

//Cursor cursorr = db.rawQuery(Query, null);

Cursor cursorr =  db.rawQuery("select * from " + DATABASE_TABLE_EHS + " where " + TASK_ID + "='" + taskid + "'" , null);

    if (cursorr.moveToFirst()) 
   {

        do {

            // your code like get columns

            }
         while (cursorr.moveToNext());
    }
}

Upvotes: 1

Krystian
Krystian

Reputation: 2290

My working example with where args (it's more clear with using it):

        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
        );

Upvotes: 11

Yaqub Ahmad
Yaqub Ahmad

Reputation: 27659

The simple way:

return mDb.rawQuery("SELECT * FROM myTable WHERE column1 = "+ someValue, null);

Upvotes: 2

Paul-Jan
Paul-Jan

Reputation: 17278

What exactly does "still doesn't work" mean?

The following code should work just fine:

public Cursor fetchTimetable() { 
    String[] columnNames = new String[] {TIMETABLE_ROWID, TIMETABLE_MODULECODE, TIMETABLE_MODULENAME, TIMETABLE_ROOM, TIMETABLE_LECTURER, TIMETABLE_TIME};
    String whereClause = "TIMETABLE_MODULECODE=123"; 

    return mDb.query(DATABASE_TABLE_TIMETABLE, columnNames, whereClause, null, null, null, null); 
}

Upvotes: 7

Avi Kumar
Avi Kumar

Reputation: 4433

db.query
        (
                TABLE_NAME,
                new String[] { TABLE_ROW_ID, TABLE_ROW_ONE, TABLE_ROW_TWO },
                TABLE_ROW_ID + "=" + rowID,
                null, null, null, null, null
        );

TABLE_ROW_ID + "=" + rowID, here "=" is the where clause

Upvotes: 7

Related Questions