在 MongoDB 文档中查找大于特定值的值?
mongodbdatabasebig data analytics更新于 2026/1/6 9:52:17
要查找大于特定值的值，以下是在 MongoDB 中使用 $gte 的语法 −
db.yourCollectionName.find({yourFieldName:{$gte:yourValue}});
Let us create a collection with documents −
> db.demo571.insertOne({"Price":140});{
"acknowledged" : true, "insertedId" : ObjectId("5e909b3439cfeaaf0b97b587")
}
> db.demo571.insertOne({"Price":100});{
"acknowledged" : true, "insertedId" : ObjectId("5e909b3639cfeaaf0b97b588")
}
> db.demo571.insertOne({"Price":110});{
"acknowledged" : true, "insertedId" : ObjectId("5e909b3839cfeaaf0b97b589")
}
> db.demo571.insertOne({"Price":240});{
"acknowledged" : true, "insertedId" : ObjectId("5e909b3c39cfeaaf0b97b58a")
}
借助 find() 方法显示集合中的所有文档 −
> db.demo571.find();
这将产生以下输出 −
{ "_id" : ObjectId("5e909b3439cfeaaf0b97b587"), "Price" : 140 }
{ "_id" : ObjectId("5e909b3639cfeaaf0b97b588"), "Price" : 100 }
{ "_id" : ObjectId("5e909b3839cfeaaf0b97b589"), "Price" : 110 }
{ "_id" : ObjectId("5e909b3c39cfeaaf0b97b58a"), "Price" : 240 }
以下是从文档中获取特定值以上的值的查询 −
> db.demo571.find({Price:{$gte:140}});
这将产生以下输出 −
{ "_id" : ObjectId("5e909b3439cfeaaf0b97b587"), "Price" : 140 }
{ "_id" : ObjectId("5e909b3c39cfeaaf0b97b58a"), "Price" : 240 }
