MongoDB查询如何获取在$or中设置了多个条件的文档？
让我们创建一个包含文档的集合-
> db.demo711.insertOne({Name:"John","Marks":75,Age:21,status:"Active"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea85c215d33e20ed1097b7e")
}
> db.demo711.insertOne({Name:"Chris","Marks":55,Age:22,status:"Active"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea85c2c5d33e20ed1097b7f")
}
> db.demo711.insertOne({Name:"Bob","Marks":45,Age:20,status:"Inactive"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea85c3e5d33e20ed1097b80")
}
> db.demo711.insertOne({Name:"David","Marks":85,Age:23,status:"Active"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea85c775d33e20ed1097b81")
}在find()方法的帮助下显示集合中的所有文档-
> db.demo711.find();
这将产生以下输出-
{ "_id" : ObjectId("5ea85c215d33e20ed1097b7e"), "Name" : "John", "Marks" : 75, "Age" : 21, "status" : "Active" }
{ "_id" : ObjectId("5ea85c2c5d33e20ed1097b7f"), "Name" : "Chris", "Marks" : 55, "Age" : 22, "status" : "Active" }
{ "_id" : ObjectId("5ea85c3e5d33e20ed1097b80"), "Name" : "Bob", "Marks" : 45, "Age" : 20, "status" : "Inactive" }
{ "_id" : ObjectId("5ea85c775d33e20ed1097b81"), "Name" : "David", "Marks" : 85, "Age" : 23, "status" : "Active" }以下是带有$or的MongoDB查询
> db.demo711.find( { $or: [ { Age: {$gte:23}}, {Marks:{$gt:80} }, {status: 'Inactive'} ] }) ;这将产生以下输出-
{ "_id" : ObjectId("5ea85c3e5d33e20ed1097b80"), "Name" : "Bob", "Marks" : 45, "Age" : 20, "status" : "Inactive" }
{ "_id" : ObjectId("5ea85c775d33e20ed1097b81"), "Name" : "David", "Marks" : 85, "Age" : 23, "status" : "Active" }热门推荐
10 儿媳买车妈妈祝福语简短
11 公司开年仪式祝福语简短
12 简短霸气的考试祝福语
13 祝美术老师祝福语简短
14 手写母亲的祝福语简短
15 幼教专干调动祝福语简短
16 关于开车的祝福语简短
17 春季祝福语女生文案简短
18 生日贺卡祝福语 简短独特