What is the $ne operator in MongoDB?

Overview

In MongoDB, the ＄ne operator signifies the not-equal operator. It is one of the comparison operators in MongoDB. It is used to match the documents whose field value is not equal to the one specified by the ＄ne operator.

Syntax

{field: {＄ne: value}

Parameters

• field: This is a valid document path.

• value: This is the specified value that will match the field values that are not equal to it.

Return value

This will return the documents whose field value does not match the specified value.

Example

In the fruit collection shown below, which contains the following documents, we will use ＄ne to match the documents whose quantity is not equal to 20:

{
     "_id" : ObjectId("60f0553e1cd9041c4014a2a3"),
     "name": "apple",
     "quantity": 20
}
{
     "_id" : ObjectId("60fd8fb788fe0e2118ddbd7c"),   
     "name": "mango",
     "quantity": 20
}
{
     "_id" : ObjectId("6120216fbb75d313c4d65af4"),    
     "name": "watermelon",
     "quantity": 10
}
{
     "_id" : ObjectId("6120216fbb75d313c4d34cd3"),    
     "name": "orange",
     "quantity": 15
}

Now, let’s match the documents whose quantity field is not equal to 20. We will do this with the help of the ＄ne operator:

db.fruits.find("quantity": {＄ne : 20})

The output will be as follows:

{
     "_id" : ObjectId("6120216fbb75d313c4d65af4"),    
     "name": "watermelon",
     "quantity": 10
}
{
     "_id" : ObjectId("6120216fbb75d313c4d34cd3"),    
     "name": "orange",
     "quantity": 15
}

Code explanation

From the result shown above, only two documents were returned. This is because when we called the ＄ne query operator, we asked it to match the documents whose quantity field was not equal to 20. In the fruits collection, there were only two documents whose quantity fields were equal to 20.