单个查询工作正常:
Cursor cursor = db.rawQuery("SELECT * FROM videoplayer where " + KEY_VIDEO_TAG + " like '%"+ searchText +"%'", null);
但是当我使用多个标签搜索时,它不起作用:
Cursor cursor = db.rawQuery("SELECT * FROM videoplayer where " + KEY_TAG_ONE + " like '%"+ searchText +"%'" + KEY_TAG_TWO + " like '%"+ searchText +"%'", null);
请让我知道,此查询的正确方法。
我认为您在这两个条件之间缺少一些逻辑运算符。 例如:
cursor = db.rawQuery("SELECT * FROM videoplayer where " + KEY_TAG_ONE + " like '%"+ searchText +"%' OR " + KEY_TAG_TWO + " like '%"+ searchText +"%'", null);
哪个应该选择KEY_TAG_ONE或KEY_TAG_TWO包含搜索文本的记录