Android：带有通配符 (%) 的 SQL rawQuery

发布于 2024-11-05 13:27:44 字数 495 浏览 1 评论 0原文

我有一个 rawQuery() ，其以下 sql 字符串与此类似：

selectionArgs = new String[] { searchString };
Cursor c = db.rawQuery("SELECT column FROM table WHERE column=?", selectionArgs);

但现在我必须在搜索中包含通配符，因此我的查询如下所示：

SELECT column FROM table WHERE column LIKE 'searchstring%'

但是当查询包含单引号时，会抛出以下 SQLite 异常： android.database.sqlite.SQLiteException: bind or column index out of range

如何在 a 中运行带有 selectArgs 的 rawQuery带有通配符元素的 SQL 查询？

原文

I'm having a rawQuery() with following sql string similar to this:

selectionArgs = new String[] { searchString };
Cursor c = db.rawQuery("SELECT column FROM table WHERE column=?", selectionArgs);

but now I have to include a wildcard in my search, so my query looks something like this:

SELECT column FROM table WHERE column LIKE 'searchstring%'

But when the query contains single quotes the following SQLite Exception is thrown: android.database.sqlite.SQLiteException: bind or column index out of range

How can I run a rawQuery with selectionArgs inside a SQL query with wildcard elements?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

酷遇一生 2024-11-12 13:27:44

您必须将%附加到selectionArgs本身：

selectionArgs = new String[] { searchString + "%" };
Cursor c = db.rawQuery("SELECT column FROM table WHERE column=?", selectionArgs);

注意：相应地，searchString字符串中的%和_仍然用作通配符！

You have to append the % to the selectionArgs itself:

selectionArgs = new String[] { searchString + "%" };
Cursor c = db.rawQuery("SELECT column FROM table WHERE column=?", selectionArgs);

Note: Accordingly % and _ in the searchString string still work as wildcards!

回复收藏 0 原文

心清如水 2024-11-12 13:27:44

Sqlite 框架自动在 ? 两边加上单引号。性格内在。

String [] selectionArgs = {searchString + "%"};
Cursor c;
// Wrap the next line in try-catch
c = db.rawQuery("SELECT column FROM table WHERE like ?", selectionArgs);

就是这样。

The Sqlite framework automatically puts single-quotes around the ? character internally.

String [] selectionArgs = {searchString + "%"};
Cursor c;
// Wrap the next line in try-catch
c = db.rawQuery("SELECT column FROM table WHERE like ?", selectionArgs);

That's it.

回复收藏 0 原文

南渊 2024-11-12 13:27:44

Brad Hein 和 Mannaz 的解决方案对我不起作用，但它确实有效：

String query = "SELECT column FROM table WHERE column=%s";
String q = String.format(query, "\""+searchString + "%\"");
Cursor c = db.rawQuery(q, null);

Brad Hein's and Mannaz's solution did not work for me, but this did:

String query = "SELECT column FROM table WHERE column=%s";
String q = String.format(query, "\""+searchString + "%\"");
Cursor c = db.rawQuery(q, null);

回复收藏 0 原文

~没有更多了~