为什么我的 MongoDB $or 查询不起作用? [英] Why doesn't my MongoDB $or query work?

问题描述

我正在尝试执行$or"搜索以匹配两个正则表达式，如下所示:

I'm trying to perform an "$or" search to match of of two regular expressions as follows:

{
    "metadata.text": {
        "$or": [
            {
                "$regex": ".*hello.*"
            },
            {
                "$regex": ".*world.*"
            }
        ]
    }
}

我正在使用 mlab.com 并收到以下错误:

I'm using mlab.com and am receiving the following error:

MongoDB error: "Command failed with error 2: 'unknown operator: $or' on server ZZZZZZZ. The full response is { "ok" : 0.0, "errmsg" : "unknown operator: $or", "code" : 2, "codeName" : "BadValue" }." Please contact [e-mail] if you need assistance.

为什么 $or 被检测为未知运算符?

Why is $or detected as an unknown operator?

推荐答案

只是因为 $or 应该是查询中的顶级运算符，如下所示:

Simply because $or should be a top level operator in your query, like this:

db.collection.find({
        "$or": [
            {
                "metadata.text": { "$regex": ".*hello.*" }
            },
            {
                "metadata.text": { "$regex": ".*world.*" }
            }
        ]
})

这篇关于为什么我的 MongoDB $or 查询不起作用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！