Android dynamic query sql using like

Question

I would make a query using like , using the % and a dynamic string, but i can't do it correctly. I have a:

public Cursor query(String s)
 {
String whereClause=COL_ATTRIBUTI + " like '%?%'";
String[] whereArgs=new String[] {s};
 return  getWritableDatabase().query(TABELLA_RICETTE,null,whereClause,whereArgs,null,null,null);
}

COL_ATTRIBUTI is the name of a column and TABELLA_RICETTE the name of the table. I would like to obtain all the thing that have s somewhere, so i use the %. but my app crash. What is the correct syntax?

Karakuri · Accepted Answer · 2016-06-22 17:42:21Z

1

I think you need to put the % wildcards in the argument if you are using the ? placeholders:

String whereClause = COL_ATTRIBUTI + " like '?'";
String[] whereArgs = new String[] {"%" + s + "%"};

answered Jun 22, 2016 at 17:42

Karakuri

38.6k12 gold badges91 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SctALE Over a year ago

i wrote String whereClause = COL_ATTRIBUTI + " like ?"; String[] whereArgs = new String[] {"%" + s + "%"};

Collectives™ on Stack Overflow

Android dynamic query sql using like

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related