jeudi 19 mars 2015

Android SQL WHERE template with IN expression

I want to use the where-clause templating (whereClause and whereArgs) with an "IN" term in the where-clause.


For example, I would like the code



String [] names = new String[]{"fred","barney","wilma"} ;
String whereTemplate = "first_name IN ?" ;
db.update(tableName, values, whereTemplate, names);


to generate SQL with the WHERE clause



WHERE first_name IN 'fred', 'barney', 'wilma'


Is this possible? (If so, how?)


Aucun commentaire:

Enregistrer un commentaire