Android database useing multiple like statements

Question

I am making a search function and I need to search using two inputs:

the category id (CID) it is a string that is contained (or not) in KEY_P_CAT_LIST (it cant be done with = as it usually isn't equal)
the search text input (input)

I need to check if the category and the input text is contained in the db record and return it in a cursor if so.

coloane is correctly defined as a [] String and is not the problem.

My atempt:

db.query(true, P_TABLE, coloane,KEY_P_CAT_LIST + " LIKE " + " AND " +CID + " LIKE", new String[] {"%"+CID+"%", "%"+input+"%"}, null, null, null, null);

Armaan Stranger · Accepted Answer · 2013-08-16 11:52:02Z

1

Try this:

db.query(true, P_TABLE, coloane,KEY_P_CAT_LIST + " LIKE ?" + " AND " +CID + " LIKE ?", new String[] {"%"+CID+"%", "%"+input+"%"}, null, null, null, null);

Hope it Helps!!

answered Aug 16, 2013 at 11:52

Armaan Stranger

3,1401 gold badge16 silver badges25 bronze badges

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

4 Comments

Mihai Bratulescu Over a year ago

It is not crashing anymore but gives no results when I give it an input, but if the input is empty it works but shows all products in the category

Mihai Bratulescu Over a year ago

actually it works, I had to add KEY_P_NAME instead of CID Thanks a lot.

Armaan Stranger Over a year ago

"Like" is case sensitive in SQLite. so i hope you have checked the input string and db data has no differences Case wise.

Mihai Bratulescu Over a year ago

when it compares the input to the database value it is not case sensitive: if I add aqua and the value is Aqua it still works. I will have to take in consideration multiple inputs such as "laptop asus" and search for each word separately then sort result by relevance but I'm just making a demo so that's for a later time.

Collectives™ on Stack Overflow

Android database useing multiple like statements

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related