SQLite确实支持正则表达式WHERE opp_Business_id REGEXP "\b" || 4 || "\b";-否则你需要匹配所有可能的组合。当它失败2/3的示例记录时，你的模式不匹配应该是显而易见的; WHERE (opp_Business_id == '4' OR opp_Business_id LIKE '%,4' OR opp_Business_id LIKE '4,%' OR opp_Business_id LIKE '%,4,%');将与LIKE进行四次比较-而REGEXP只有一次比较。

这个问题是关于Android平台的，Android's Sqlite不支持REGEXP关键字。你必须这样写你的查询[为了更好地理解，我使用了Room语法]：

@Query(
    "SELECT * FROM tbl_opportunity WHERE " +
            "(" +
            "',' || opp_Business_id || ',' LIKE '%' || :businessId || ',%' OR " +
            "',' || opp_Business_id || ',' LIKE '%' || :businessId OR " +
            "',' || opp_Business_id || ',' LIKE :businessId || '%'" +
            ") "
)
suspend fun getByBusinessId(businessId: Int): List<Opportunity>

字符串