Visit complete MongoDB roadmap
MongoDB Topic

$ne

$ne

In MongoDB, the $ne operator is used to filter documents where the value of a specified field is not equal to a specified value.

Usage

To use the $ne comparison operator, include it within the query document as:

{
  field: {
    $ne: value;
  }
}
  • field : The field that you want to apply the $ne operator on.
  • value : The value that you want to filter out from the results.

Example

Let’s say you have a collection called products with documents like:

{ _id: 1, name: "Apple", category: "Fruits" }
{ _id: 2, name: "Banana", category: "Fruits" }
{ _id: 3, name: "Carrot", category: "Vegetables" }

If you want to query all documents where the category is not “Fruits”, you would execute:

db.products.find({ category: { $ne: 'Fruits' } });

The result would be:

{ "_id" : 3, "name" : "Carrot", "category" : "Vegetables" }

Additional Notes

  • The $ne operator also works with compound conditions.
  • You can compare values of different types (e.g., a string and a number), but remember that MongoDB uses BSON’s comparison rules for different data types.

And that’s a brief summary of the $ne operator. Use it when you want to filter documents where a specified field’s value is not equal to another specified value. Happy querying!

More Topics

Explore related content

View All Topics
Loved by 100K+ Developers

Start Your Learning
Journey Today

Join thousands of developers who are leveling up their skills with structured roadmaps and expert guidance

No credit card required
Always free
Track your progress