Using selectionArgs doesn't work in a query

Question

I'm trying to use the following:

String dbquery = "Select * From stops where stopname LIKE '%?%' LIMIT 100";
String[] uinputarray = {uinput};
Cursor c = sDB.rawQuery(dbquery, uinputarray);

This consistently crashes.

Curiously, if I use the old test code of:

Cursor c = sDB.rawQuery("Select * From stops where stopname LIKE '%" + uinput + "%' LIMIT 100", null);

It works flawlessly.

I've been reading up on selectionArgs and I honestly can't see anything wrong with what I've done.

What am I doing wrong?

Thanks guys

ankita gahoi · Accepted Answer · 2012-05-04 09:33:16Z

7

You have to append the % to the selectionArgs itself:

selectionArgs = new String[] { searchString + "%" };

Cursor c = db.rawQuery("SELECT column FROM table WHERE column=?", selectionArgs);

Note: Accordingly % and _ in the searchString string still work as wildcards!

answered May 4, 2012 at 9:33

ankita gahoi

1,5623 gold badges15 silver badges30 bronze badges

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

2 Comments

Mark Over a year ago

Thank you! So that's what I was doing wrong! It works great now. I'd give you an upvote but it requires more reputation. (sorry)

ankita gahoi Over a year ago

if answer is correct you should mark this as correct answer .

Collectives™ on Stack Overflow

Using selectionArgs doesn't work in a query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related