[Solved] Like query for multiple condition check android

Question

I think you are missing some logic operator between those two conditions. eg.:

 cursor = db.rawQuery("SELECT * FROM videoplayer where " + KEY_TAG_ONE + " like '%"+ searchText +"%' OR " + KEY_TAG_TWO + " like '%"+ searchText +"%'", null);

Which should select records where KEY_TAG_ONE or KEY_TAG_TWO contains searchText

Accepted Answer

I think you are missing some logic operator between those two conditions. eg.:

 cursor = db.rawQuery("SELECT * FROM videoplayer where " + KEY_TAG_ONE + " like '%"+ searchText +"%' OR " + KEY_TAG_TWO + " like '%"+ searchText +"%'", null);

Which should select records where KEY_TAG_ONE or KEY_TAG_TWO contains searchText