MongoDB $ne Operator (original) (raw)

Last Updated : 12 Jul, 2025

**MongoDB ne∗∗or"notequals"operatorisoneofthecomparisonoperators.Thene or "not equals" operator is one of the comparison operators. The ne∗∗or"notequals"operatorisoneofthecomparisonoperators.Thene operator selects those documents where the field value is not equal to the given value.

It also includes those documents that do not contain the specified field. You can use this operator in methods like find(), update(), etc. as per your requirement.

**Syntax

{field: {$ne: value}}

MongoDB $ne Operator Examples

In the following examples, we are working with:

**Database: GeeksforGeeks

**Collection: employee

**Document: four documents that contain the details of the employees in the form of field-value pairs.

demo database and collection creation

**Example 1

In this example, we are selecting those documents where the value of the experienceYear field is not equal to 2.

**Query:

db.employee.find({experienceYear: {$ne: 2}}) .pretty()

**Output:

example 1 output

**Example 2

In this example, we are selecting only those documents where the last name of the employees is not Goyal.

**Query:

db.employee.find({"name.last": {$ne: "Goyal"}}) .pretty()

**Output:

**Example 3

In this example, we are selecting those documents where the points array is not equal to the specified array.

**Query:

db.employee.find ({points: {$ne: [2,4,6]}}).pretty()

**Output:

example 3 output

**Example 4

In this example, we are updating the salary to 55000 of those employees whose department is not HR. Or in other words, set the value of the salary field to 55000 of those documents whose department field value is not equal to HR.

**Query:

db.employee.update({department: {$ne: "HR}}, {$set: {salary: 55000 }})
WriteResult({"nMatched" : 1, "nUpserted" :0, "Modified" :1})
db.employee.find({department: {$ne: "HR"}}). pretty()

**Output:

Key Takeaways About $ne Operator