SQLite - 将 LIKE 子句与 AND 子句一起使用

Question

所以我需要在数据库中搜索一个表。

我像这样创建了一个SQLite查询

String selection = COLUMN_1 + " LIKE ? AND " + COLUMN_2 + " ?= AND " + COLUMN_3 + " ?=";
String selectionArgs[] = {"%" + value1 + "%", value2 , value3 };
Cursor cursor = db.query(TABLE_1, null, selection, selectionArgs, null, null, null);

我收到以下错误

SQLiteException: near "?": syntax error (Sqlite code 1): , while compiling: SELECT * FROM TABLE_1 WHERE COLUMN_1 LIKE ? AND COLUMN_2 ?= AND COLUMN_3 ?=, (OS error - 2:No such file or directory)

在尝试了许多不同的变体和研究之后，我放弃了，写了一个rawQuery。

String query = "SELECT * FROM " + ITEMS_CONTENT_TABLE + " WHERE " + ITEM_NAME + " LIKE '%" + name + "%' AND " + BASE_CATEGORY_NAME + " = '" + baseCategoryName + "' AND " + BASE_CATEGORY_SRC_PATH + " = '" + baseCategorySrcPath + "';";
Cursor cursor = db.rawQuery(query , null);

哪个工作无缝！

我的问题是为什么前者不起作用？如果它真的是语法错误，那么它也不应该在后面的示例中工作。

Answer 1

更改查询

如下

String selection = COLUMN_1 + " LIKE ? AND " + COLUMN_2 + " =? AND " + COLUMN_3 + " =?"

Answer 2

在我的情况下，下面的查询工作正常。

Cursor c = db.rawQuery("Select ConsAcNo From FieldUtilityData Where ConsAcNo like '%" + txtConsAcNo.getText() + "%' and ProjectNo = '" + gp.city + "' and IsCompleted = 'N' and ConsAcNo not in (SELECT CONS_ACCOUNT_NO FROM FieldTestDataFinal) Limit 15", null);