如何基于MongoDB中的数组过滤文档？
让我们创建一个包含文档的集合-
> db.demo453.insertOne(
... { _id: 101, details: [ { Name: "David", Marks: 60 }, { Name: "Mike", Marks: 55} ] }
... )
{ "acknowledged" : true, "insertedId" : 101 }
> db.demo453.insertOne(
... { _id: 102, details: [ { Name: "Bob", Marks: 80 }, { Name: "Sam", Marks: 78} ] }
... )
{ "acknowledged" : true, "insertedId" : 102 }
> db.demo453.insertOne(
... { _id: 103, details: [ { Name: "Carol", Marks: 67 }, { Name: "John", Marks: 79} ] }
... )
{ "acknowledged" : true, "insertedId" : 103 }在find()方法的帮助下显示集合中的所有文档-
> db.demo453.find();
这将产生以下输出-
{ "_id" : 101, "details" : [ { "Name" : "David", "Marks" : 60 }, { "Name" : "Mike", "Marks" : 55 } ] }
{ "_id" : 102, "details" : [ { "Name" : "Bob", "Marks" : 80 }, { "Name" : "Sam", "Marks" : 78 } ] }
{ "_id" : 103, "details" : [ { "Name" : "Carol", "Marks" : 67 }, { "Name" : "John", "Marks" : 79 } ] }以下是基于数组过滤文档的查询-
> db.demo453.find(
... { details: { $elemMatch: {Marks: { $gte: 75 } } } }
... )这将产生以下输出-
{ "_id" : 102, "details" : [ { "Name" : "Bob", "Marks" : 80 }, { "Name" : "Sam", "Marks" : 78 } ] }
{ "_id" : 103, "details" : [ { "Name" : "Carol", "Marks" : 67 }, { "Name" : "John", "Marks" : 79 } ] }热门推荐
10 访贫问苦祝福语简短句子
11 简短的祝福语中秋搞笑
12 生日祝福语 简短独特潮
13 幼师离别祝福语老师简短
14 简短搞笑蛋糕生日祝福语
15 生完孩子祝福语简短
16 保洁阿姨送来祝福语简短
17 送给客人简短的祝福语
18 调皮祝福语老师文案简短