使用MongoDB从数组中的对象的一部分查询
要查询数组中对象的一部分，请使用$findOne()和$all。首先让我们创建一个包含文档的集合-
> db.demo25.insertOne(
... {
...
... "Details":[
... {
... "UserId":"Carol101",
... "UserName":"Carol"
... },
... {
... "UserId":"David102",
... "UserName":"David"
... }
... ]
... }
... );
{
"acknowledged" : true,
"insertedId" : ObjectId("5e14c86e22d07d3b95082e77")
}
> db.demo25.insertOne(
... {
...
... "Details":[
... {
... "UserId":"Chris101",
... "UserName":"Chris"
... },
... {
... "UserId":"Mike102",
... "UserName":"Mike"
... }
... ]
... }
... );
{
"acknowledged" : true,
"insertedId" : ObjectId("5e14c86f22d07d3b95082e78")
}在find()方法的帮助下显示集合中的所有文档-
> db.demo25.find();
这将产生以下输出-
{ "_id" : ObjectId("5e14c86e22d07d3b95082e77"), "Details" : [ { "UserId" : "Carol101", "UserName" : "Carol" }, { "UserId" : "David102", "UserName" : "David" } ] }
{ "_id" : ObjectId("5e14c86f22d07d3b95082e78"), "Details" : [ { "UserId" : "Chris101", "UserName" : "Chris" }, { "UserId" : "Mike102", "UserName" : "Mike" } ] }这是如何从数组中对象的一部分进行查询-
> db.demo25.findOne({ "Details.UserId":{$all : ["Carol101","David102"]}});这将产生以下输出-
{
"_id" : ObjectId("5e14c86e22d07d3b95082e77"),
"Details" : [
{
"UserId" : "Carol101",
"UserName" : "Carol"
},
{
"UserId" : "David102",
"UserName" : "David"
}
]
}热门推荐
10 伴娘祝福语长文案简短
11 集体生日祝福语简短的
12 喜得孙子祝福语简短唯美
13 欢送退休人员简短祝福语
14 搞笑英译祝福语简短句
15 幼师离别祝福语老师简短
16 简短的祝福语中秋搞笑
17 新年祝福语大全简短成语
18 校庆祝福语简短横幅