How to Use $not Operator in MongoDB Queries

In MongoDB, use the $not operator to invert a query condition, returning documents where the condition is false. It is used inside a query expression to negate conditions like $regex or comparison operators.

Syntax

The $not operator is used inside a query expression to negate a condition. It takes a query operator as its value and returns documents that do not satisfy that condition.

• { field: { $not: { : } } } - Negates the condition on field.
• can be any MongoDB query operator like $regex, $gt, $lt, etc.

json

{
  field: { $not: { <operator>: <value> } }
}

Example

This example finds all documents in the users collection where the name field does NOT start with the letter 'A'. It uses $not with $regex to negate the pattern match.

mongodb

db.users.find({
  name: { $not: { $regex: /^A/ } }
})

Output

[
  { "_id": 2, "name": "Bob" },
  { "_id": 3, "name": "Charlie" }
]

Common Pitfalls

One common mistake is using $not directly with a value instead of a query operator. $not requires an operator expression inside it.

Wrong usage example:

{ name: { $not: "Alice" } }

This will cause an error because $not expects an operator like $regex or $gt.

Correct usage example:

{ name: { $not: { $eq: "Alice" } } }

Quick Reference

Usage	Description
{ field: { $not: { $regex: /pattern/ } } }	Find documents where field does NOT match regex pattern
{ field: { $not: { $gt: 10 } } }	Find documents where field is NOT greater than 10
{ field: { $not: { $eq: value } } }	Find documents where field is NOT equal to value

Key Takeaways

Use $not inside a query operator expression to negate conditions in MongoDB.

$not requires an operator like $regex, $gt, $eq inside it, not a direct value.

It helps find documents where a condition is false or does not match.

Common mistake: using $not with a direct value causes errors.

Combine $not with other operators for flexible negation queries.