SQLite in operator in query()

Question

I'm calling SQLite like this

String[] args = new String[]{"(A,B)"}
Cursor cur = db.query("tab1", null, "name in ?", args, null, null, null);

and receiving Exception:

android.database.sqlite.SQLiteException: near "?": syntax error: , while compiling: SELECT * FROM tab1 WHERE name in ?

How to use in operator in query() ?

I already tried

String[] args = new String[]{"('A','B')"}

Answer 1

String[] args = new String[]{A,B} // if A, B are variables
String[] args = new String[]{"A","B"}    
Cursor cur = db.query("tab1", null, "name in (?,?)", args, null, null, null);  

Answer 2

While working on a project and struggling with this very same question I found these other questions (and answers) helpful:

1. Sqlite Query for multiple values in one columm
2. Android/SQLite IN clause and placeholders

Here is what I've found works:

String[] args = new String[] {"A", "B"};
Cursor cur = db.query("tab1", null, "name in(?,?)", args, null, null, null);

As will:

String args = "A, B";
Cursor cur = db.query("tab1", null, "name in(" + args + ")", null, null, null, null);

So you can either use multiple ? with the IN() statement and match each with an element in selectionArgs array (like the first example). If you have multiple conditions in your WHERE clause, make sure to match the ? with the correct element in selectionArgs:

String[] args = new String[] {"Current", "A", "B"};
Cursor cur = db.query("tab1", null, "IsCurrent=? AND name in(?,?)", args, null, null, null);

Or you can just use a string made up of comma-delineated arguments directly in the IN() statement in the selection string itself (like the second example).

The referenced questions seemed to indicate that you could use a single ? in the IN() and somehow expand the associated parameter(s), but I was not able to get that to work.