$ne operator in MongoDB
This article will discuss how the $ne operator works in MongoDB. In addition, we will list its differences from the $not operator.
$ne operator in MongoDB
$neis an operator in MongoDB that stands for not equal to. This will compare the values of the fields and check if they are equal.
grammar:
{field: {$ne: value}}
Suppose you have the following document in employees collection.
> db.employee.find().pretty()
{"_id":1, "name":"Alice", "salary": 1500, "gender":"Female"}
{"_id":2, "name":"Bob", "salary": 2500, "gender":"male"}
{"_id":3, "name":"Jhon", "salary": 3500, "gender":"male"}
{"_id":4, "name":"Grace", "salary": 4500, "gender":"female"}
Now, you want to see all male employees. Then, your query should look like this:
> db.employee.find({gender:{$ne: female}}).pretty()
{"_id":2, "name":"Bob", "salary": 2500, "gender":"male"}
{"_id":3, "name":"Jhon", "salary": 3500, "gender":"male"}
Another example, let's say you are asked to display the women whose salary is greater than or equal to 4000. So, the query should be:
> db.employee.find({gender:{$ne: male}, salary:{$gte:4000}}).pretty()
{"_id":4, "name":"Grace", "salary": 4500, "gender":"female"}
Difference between $not and $ne operators
You have seen the syntax of the $ne operator above. If you noticed, $ne only takes a value as a parameter.
It simply checks if the document has an exact value in a given field. In some cases, we may need a logical expression instead of a constant value; then, we will use $not.
grammar:
{ field: { $not: { <operator-expression> } } }
Here are the similarities and differences between $ne and $not:
| $ne | $not |
|---|---|
| Takes a value as a parameter. | Takes a logical expression as an argument. |
| Nested queries are not supported. | You can use nested queries with the $not operator. |
| $ne selects documents where the field value is not equal to the specified value, including documents that do not contain the field. | $not selects documents that do not match the operator expression, including documents that do not contain the field. |
| $ne does not support regular expressions. | $Regular expressions are not supported. |
For reprinting, please send an email to 1244347461@qq.com for approval. After obtaining the author's consent, kindly include the source as a link.
Related Articles
MongoDB $Set Operator
Publish Date：2025/04/11 Views：159 Category：MongoDB
-
With the help of this article, you will learn how to use $set the operator to partially update objects in MongoDB so that the new object overlaps/merges with the existing object. The $set operator replaces the value of a field with a given
Difference between $push and $addToSet in MongoDB
Publish Date：2025/04/11 Views：63 Category：MongoDB
-
This article explains the operators in MongoDB. What is the purpose of $push and $addToSet operators. Furthermore, the difference between these two operators is given in the code snippet. This article discusses the following topics. Operato
Sort a collection by date in MongoDB
Publish Date：2025/04/11 Views：64 Category：MongoDB
-
In this MongoDB tutorial, the problem of sorting a collection in MongoDB is discussed. The different ways to sort a collection in the database are briefly explained. Using sort() function in MongoDB This problem is solved using the MongoDB
Counting records in MongoDB
Publish Date：2025/04/11 Views：146 Category：MongoDB
-
This article discusses operators in MongoDB, aggregation operators, and different ways to calculate the total number of records. Operations in MongoDB CRUD operations are a user interface concept that allows users to browse, search, and cha
Pretty printing in MongoDB
Publish Date：2025/04/11 Views：150 Category：MongoDB
-
This article will discuss how to use pretty printing in MongoDB to display formatted results. Pretty printing in MongoDB A cursor is an object that allows programmers in the Mongo world to iterate over documents in a Mongo collection. Altho
MongoDB Adding Elements to an Array
Publish Date：2025/04/11 Views：136 Category：MongoDB
-
This article will cover the various ways to add to an array in MongoDB. Adding to an array in MongoDB Use the $push operator to add values to an array The $push operator is one of the various array update operators provided by MongoDB
MongoDB Search by ID
Publish Date：2025/04/11 Views：131 Category：MongoDB
-
The following article provides an overview of MongoDB find by Id() method. MongoDB provides a find by Id() function which can retrieve documents matching a user id. To use search by Id() in MongoDB, you need to use the find() function. If n
MongoDB starts with a query
Publish Date：2025/04/10 Views：195 Category：MongoDB
-
In this MongoDB article, users will learn how to start queries using $regex. It provides regular expression functionality for pattern matching strings in queries. MongoDB starts querying using $regex If you want to use $regex , use one of t
Export all collections in MongoDB
Publish Date：2025/04/10 Views：188 Category：MongoDB
-
This MongoDB tutorial will show you how to export all MongoDB collections. Most databases and language frameworks allow you to export data. This makes the data useful to other programs, applications, or languages in various forms. CSV
