Sqlite 模糊查询区分大小写

最新推荐文章于 2025-03-13 14:55:30 发布

王人冉

最新推荐文章于 2025-03-13 14:55:30 发布

阅读量1.5k

点赞数 2

分类专栏： SQLite

本文链接：https://blog.youkuaiyun.com/w690333243/article/details/90183759

版权

SQLite 专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了在SQLite数据库中如何使用PRAGMA指令来控制LIKE操作符的大小写敏感性，这对于精确检索非常重要。同时，文章提供了特殊字符转义的方法，确保了搜索内容的准确性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

PRAGMA case_sensitive_like=ON;
PRAGMA case_sensitive_like=OFF;
select * from  test  where  destid = 12345   and content like "%ab%" ;

String whereClause = "id= ? and age=?  and ( country like '%" + str + "%' or name like '%" + str + "%')"

必须先设置PRAGMA case_sensitive_like=ON; 才会开启模糊查询的区分大小写（模糊查询默认不区分大小写）
https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite

https://blog.youkuaiyun.com/tietao/article/details/6890350

搜索内容中含有特殊字符时，转义

public static String sqliteEscape(String keyWord){
        keyWord = keyWord.replace("/", "//");
        keyWord = keyWord.replace("'", "''");
        keyWord = keyWord.replace("[", "/[");
        keyWord = keyWord.replace("]", "/]");
        keyWord = keyWord.replace("%", "/%");
        keyWord = keyWord.replace("&","/&");
        keyWord = keyWord.replace("_", "/_");
        keyWord = keyWord.replace("(", "/(");
        keyWord = keyWord.replace(")", "/)");
        return keyWord;
    }

https://blog.youkuaiyun.com/gfdhjf/article/details/86621384
https://blog.youkuaiyun.com/fantianheyey/article/details/9199235
https://blog.youkuaiyun.com/shareye1992/article/details/51699763#commentsedit
https://blog.youkuaiyun.com/it__sky/article/details/82740512
https://blog.youkuaiyun.com/ameyume/article/details/8007149
https://www.cnblogs.com/jintianhu/archive/2011/09/23/2186664.html

https://www.jianshu.com/p/85b9cefd8d56 Android目前流行三方数据库ORM分析及对比
https://blog.youkuaiyun.com/qq_22703355/article/details/80804876 Android 数据库框架总结，总有一个适合你！
https://blog.youkuaiyun.com/tangjiean/article/details/51729371 okhttp连接池复用机制