vendredi 13 février 2015

Android SQLite how to use where clause?

In the below code i am selecting KEY_ROWID = 12 from my Table, but now i need to select KEY_ROWID greater than 12 but less than 20.how i can specify where clause in the below query.



mDb.query(true, SQLITE_TABLE, new String[] {
KEY_ROWID },
KEY_ROWID + "=?"
new String[] {"12"},
null, null, KEY_ITEM , null);


i donot want to write rawQuery.


Aucun commentaire:

Enregistrer un commentaire