如何使用 mongodb 在内部数组中搜索字符串？

如何在多维数组中搜索值， 例如我想搜索examplemongodb中以下数据中的关键字 我曾经从命令获取所有数据

>db.info.find()

{
    "_id" : ObjectId("4f74737cc3a51043d26f4b90"),
    "id" : "12345",
    "info" : [
            {
                    "sno" : 1,
                    "name" : "ABC",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            },
            {
                    "sno" : 2,
                    "name" : "XYZ",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            },
            {
                    "sno" : 3,
                    "name" : "XYZ",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            },
            {
                    "sno" : 4,
                    "name" : "ABC",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            },
            {
                    "sno" : 5,
                    "name" : "Rohan",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            }
    ]
}

现在，要查找具有example我用命令

>db.info.find({"info.email":"example"})它给出了

{
    "_id" : ObjectId("4f74737cc3a51043d26f4b90"),
    "id" : "12345",
    "info" : [
            {
                    "sno" : 1,
                    "name" : "ABC",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            },
            {
                    "sno" : 2,
                    "name" : "XYZ",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            },
            {
                    "sno" : 3,
                    "name" : "XYZ",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            },
            {
                    "sno" : 4,
                    "name" : "ABC",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            },
            {
                    "sno" : 5,
                    "name" : "Rohan",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            }
    ]
}

但我只想要 5 个子行中的 3 个，例如

{
    "_id" : ObjectId("4f74737cc3a51043d26f4b90"),
    "id" : "12345",
    "info" : [
            {
                    "sno" : 1,
                    "name" : "ABC",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            },
            {
                    "sno" : 2,
                    "name" : "XYZ",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            },
            {
                    "sno" : 5,
                    "name" : "Rohan",
                    "email" : "[email protected] /cdn-cgi/l/email-protection"
            }
    ]
}

Rohan，MongoDB 总是返回whole您正在搜索的文档。您不能只是让它返回在其中找到关键字的数组元素。如果您想这样做，那么您需要确保“信息”字段中的所有嵌入文档都在其自己的集合中。这可能意味着您需要将它们链接回“信息”集合中的原始文档。也许是这样的：

{
    "sno" : 1,
    "name" : "ABC",
    "email" : "[email protected] /cdn-cgi/l/email-protection"
    "info_id" : "12345",
},

或者，您当然可以在 PHP 中进行后处理以仅获取您想要的行。