SQLite进行记录查询时错误

List currentList = new ArrayList<>();
Cursor cursor = db.rawQuery("select name from SearchHistory order by priority", null);
while (cursor.moveToNext()) {
currentList.add(cursor.getString(0));
}

        数据库中已经有此条数据了，再进行查询时总是出现 no such column 错误，求解答

把数据表放上来看看呗

db.execSQL("CREATE TABLE SearchHistory(id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,priority INTEGER)");然后在执行Cursor cursor = db.rawQuery("select * from SearchHistory where name = " + searchName, null);这句的时候就总出现 no such column的错误，但是数据库中已经存在searchName这条记录了

Cursor cursor = db.rawQuery("select * from SearchHistory where name=?", searchName);