MongoDB $gt 操作符 (大于)2024 年 9 月 6 日 | 3 分钟阅读 MongoDB 中的 $gte 操作符是什么？MongoDB 提供了各种比较查询操作符。 $gte（大于或等于）操作符是这些操作符之一。 $gte 操作符用于选择字段值大于或等于（即 >=）给定值的文档。您可以根据您的需求在 update、find 等方法中使用此操作符。 $gte 操作符的语法示例在下面的示例中，我们将使用 >db.employee.find()
{
"_id" : 1,
"name" : "John",
"father_name" : "Thomas",
"department" : "Contain Writting",
"experience" : 2,
"mobile_no" : 9856321478,
"gender" : "Male",
"salary" : 22000,
"age" : 26
}
{
"_id" : 2,
"name" : "William",
"father_name" : "Rebort",
"department" : "Softwre Tester",
"experience" : 1,
"mobile_no" : 7896541478,
"gender" : "Male",
"salary" : 20000,
"age" : 21
}
{
"_id" : 3,
"name" : "Ava",
"father_name" : "William",
"department" : "Marketing manager",
"experience" : 5,
"mobile_no" : 8789654178,
"gender" : "Female",
"salary" : 36500,
"age" : 25
}
{
"_id" : 4,
"name" : "Olivia",
"father_name" : "Noah",
"department" : null,
"experience" : 4,
"mobile_no" : 9045641478,
"gender" : "Female",
"salary" : 30000,
"age" : 27
}
{
"_id" : 5,
"name" : "Elijah",
"father_name" : "John",
"department" : "HR",
"experience" : 0,
"mobile_no" : 6589741230,
"gender" : "Male",
"salary" : 15000,
"age" : 20
}
{
"_id" : 6,
"name" : "John",
"father_name" : "Liam",
"department" : "Softwre Tester",
"experience" : 10,
"mobile_no" : 9014536987,
"gender" : "Male",
"salary" : 55000,
"age" : 30
}
示例 1：使用 $gte 操作符 在这个例子中，我们正在寻找工资水平等于或大于 20000 的文档 输出 {
"_id" : 1,
"name" : "John",
"father_name" : "Thomas",
"department" : "Contain Writting",
"experience" : 2,
"mobile_no" : 9856321478,
"gender" : "Male",
"salary" : 22000,
"age" : 26
}
{
"_id" : 2,
"name" : "William",
"father_name" : "Rebort",
"department" : "Softwre Tester",
"experience" : 1,
"mobile_no" : 7896541478,
"gender" : "Male",
"salary" : 20000,
"age" : 21
}
{
"_id" : 3,
"name" : "Ava",
"father_name" : "William",
"department" : "Marketing manager",
"experience" : 5,
"mobile_no" : 8789654178,
"gender" : "Female",
"salary" : 36500,
"age" : 25
}
{
"_id" : 4,
"name" : "Olivia",
"father_name" : "Noah",
"department" : null,
"experience" : 4,
"mobile_no" : 9045641478,
"gender" : "Female",
"salary" : 30000,
"age" : 27
}
{
"_id" : 6,
"name" : "John",
"father_name" : "Liam",
"department" : "Softwre Tester",
"experience" : 10,
"mobile_no" : 9014536987,
"gender" : "Male",
"salary" : 55000,
"age" : 30
}
示例 2：另一个字段 在这个例子中，我们正在寻找年龄大于或等于 26 的文档。 输出 {
"_id" : 1,
"name" : "John",
"father_name" : "Thomas",
"department" : "Contain Writting",
"experience" : 2,
"mobile_no" : 9856321478,
"gender" : "Male",
"salary" : 22000,
"age" : 26
}
{
"_id" : 4,
"name" : "Olivia",
"father_name" : "Noah",
"department" : null,
"experience" : 4,
"mobile_no" : 9045641478,
"gender" : "Female",
"salary" : 30000,
"age" : 27
}
{
"_id" : 6,
"name" : "John",
"father_name" : "Liam",
"department" : "Softwre Tester",
"experience" : 10,
"mobile_no" : 9014536987,
"gender" : "Male",
"salary" : 55000,
"age" : 30
}
示例 3：使用 $gte 操作符更新值 在这个例子中，我们正在更新工作经验大于或等于 3 年的员工的工资字段。 输出 {
"_id" : 3,
"name" : "Ava",
"father_name" : "William",
"department" : "Marketing manager",
"experience" : 5,
"mobile_no" : 8789654178,
"gender" : "Female",
"salary" : 50000,
"age" : 25
}
{
"_id" : 4,
"name" : "Olivia",
"father_name" : "Noah",
"department" : null,
"experience" : 4,
"mobile_no" : 9045641478,
"gender" : "Female",
"salary" : 50000,
"age" : 27
}
{
"_id" : 6,
"name" : "John",
"father_name" : "Liam",
"department" : "Softwre Tester",
"experience" : 10,
"mobile_no" : 9014536987,
"gender" : "Male",
"salary" : 50000,
"age" : 30
}
下一话题MongoDB $lt 操作符 |
我们请求您订阅我们的新闻通讯以获取最新更新。
我们提供所有技术（如 Java 教程、Android、Java 框架）的教程和面试问题
G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India
Python
Java
JavaScript
SQL
C
C++
HTML
CSS
React
Node.js
Spring Boot
C#
PHP
MySQL
MongoDB
AI
ML
DSA
DBMS
OS
Aptitude
Reasoning