模糊查询 arrayExists(x -> position(name, x), [])

匹配name字段包含特定内容的数据:

SELECT mongo_id, name, arrayFilter(x -> position(name, x) > 0, ['每日', '新闻']) AS match FROM a4_gene.organization WHERE arrayExists(x -> position(name, x), ['每日', '新闻'])