Sqlite 模糊查询 区分大小写

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.csdn.net/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.csdn.net/gfdhjf/article/details/86621384
https://blog.csdn.net/fantianheyey/article/details/9199235
https://blog.csdn.net/shareye1992/article/details/51699763#commentsedit
https://blog.csdn.net/it__sky/article/details/82740512
https://blog.csdn.net/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.csdn.net/qq_22703355/article/details/80804876 Android 数据库框架总结，总有一个适合你！
https://blog.csdn.net/tangjiean/article/details/51729371 okhttp连接池复用机制