Using String[] selectionArgs in SQLiteDatabase.query()

Question

How do I use the String[] selectionArgs in SQLiteDatabase.query()? I wish I could just set it to null, as I have no use for it. I am just trying to load an entire unsorted table from a database into a Cursor. Any suggestions on how to achieve this?

Answer 1

selectionArgs replace any question marks in the selection string.

for example:

String[] args = { "first string", "[email protected]" }; Cursor cursor = db.query("TABLE_NAME", null, "name=? AND email=?", args, null); 

as for your question - you can use null

Answer 2

Yes, you may set all parameters to null except the table name.

for example:

Cursor cursor = db.query("TABLE_NAME", null, null, null, null, null, null);