在MongoDB的对象数组中查找所有具有两个特定ID的所有文档？
您可以为此使用$and运算符。首先让我们创建一个包含文档的集合-
> db.twoSpecificIdsDemo.insertOne(
... {
... PlayerId:1,
... "PlayerDetails": [{
... id: 100,
... "PlayerName":"Chris"
... },{
... id: 101,
... "PlayerName":"Sam"
... },{
... id: 102,
... "PlayerName":"Robert"
... },{
... id: 103,
... "PlayerName":"Carol"
... }]
... }
... );
{
"acknowledged" : true,
"insertedId" : ObjectId("5cd3e130edc6604c74817ce4")
}
> db.twoSpecificIdsDemo.insertOne(
... {
... PlayerId:1,
... "PlayerDetails": [{
... id: 104,
... "PlayerName":"Mike"
... },{
... id: 105,
... "PlayerName":"Bob"
... },{
... id: 102,
... "PlayerName":"Ramit"
... },{
... id: 106,
... "PlayerName":"David"
... }]
... }
... );
{
"acknowledged" : true,
"insertedId" : ObjectId("5cd3e167edc6604c74817ce5")
}以下是在find()方法的帮助下显示集合中所有文档的查询-
> db.twoSpecificIdsDemo.find().pretty();
这将产生以下输出-
{
"_id" : ObjectId("5cd3e130edc6604c74817ce4"),
"PlayerId" : 1,
"PlayerDetails" : [
{
"id" : 100,
"PlayerName" : "Chris"
},
{
"id" : 101,
"PlayerName" : "Sam"
},
{
"id" : 102,
"PlayerName" : "Robert"
},
{
"id" : 103,
"PlayerName" : "Carol"
}
]
}
{
"_id" : ObjectId("5cd3e167edc6604c74817ce5"),
"PlayerId" : 1,
"PlayerDetails" : [
{
"id" : 104,
"PlayerName" : "Mike"
},
{
"id" : 105,
"PlayerName" : "Bob"
},
{
"id" : 102,
"PlayerName" : "Ramit"
},
{
"id" : 106,
"PlayerName" : "David"
}
]
}这是在MongoDB中的对象数组中查找具有两个特定ID的所有文档的查询-
> db.twoSpecificIdsDemo.find( { $and : [ { "PlayerDetails.id" : 102 }, { "PlayerDetails.id" : 103 } ] } ).pretty();这将产生以下输出-
{
"_id" : ObjectId("5cd3e130edc6604c74817ce4"),
"PlayerId" : 1,
"PlayerDetails" : [
{
"id" : 100,
"PlayerName" : "Chris"
},
{
"id" : 101,
"PlayerName" : "Sam"
},
{
"id" : 102,
"PlayerName" : "Robert"
},
{
"id" : 103,
"PlayerName" : "Carol"
}
]
}热门推荐
5 天仙配简短祝福语
10 小学同学简短祝福语
11 2026新年的简短祝福语
12 狗年同事拜年祝福语简短
13 9字祝福语简短创意
14 婚礼伴娘祝福语大全简短
15 吃饭后祝福语2026简短
16 生日祝福语 简短独特情话
17 女孩结婚祝福语大全简短
18 事业祝福语简短网名