MongoDB NOT operator ( $not ) (original) (raw)

Last Updated : 5 May, 2026

The MongoDB $not operator negates a query condition and returns documents that do not match the specified expression, helping exclude unwanted results in complex filters.

• Reverses the logic of another query condition.
• Commonly used with gt,gt, gt,eq, in,in, in,ne, and similar operators.
• Returns documents where the condition is not satisfied, including those where the field is missing.
• Can be used with regular expressions to exclude pattern matches.

Syntax

{ field: { $not: { } } }

• **field: The field to apply the condition on.
• **operator-expression: The condition to negate (e.g., gt,gt, gt,eq, in,in, in,regex).

Examples of Using $not Operator in MongoDB

In the following examples, we are working with:

• **Database: GeeksforGeeks
• **Collection: contributor
• **Document: Three documents that contain the details of the contributors in the form of field-value pairs.

Example 1: Matching values using $not operator

Retrieving only those contributor’s documents whose salary is not greater than 2000.

**Query:

db.contributor.find({salary: {$not: {$gt: 2000}}})

**Output:

Example 2: Matching values in nested/embedded documents using $not operator

Retrieving only those contributor’s documents whose age is not equal to 24.

**Query:

db.contributor.find({"personal.age": {$not: {$eq: 24}}})

**Output:

Example 3: Matching values in an array using $not operator

Retrieving only those contributor’s documents where the language is not Java or Perl.

**Query:

db.contributor.find({ language: {$not: {$in: ["Java", "Perl"]}}})

**Output:

Behavior of $not with Different Data Types

The MongoDB $not operator works across different data types, but its behavior can vary with arrays and missing fields, sometimes producing unexpected results.

• **Arrays: Negates the condition for each element in the array.
• **Null or missing fields: Matches documents where the field is absent or does not satisfy the condition.

Best Practices for Using the $not Operator

Use $not carefully with clear conditions to avoid performance issues and unexpected results.

• **Use with other operators: Combine notwithnot with notwithgt, lt,lt, lt,eq, $in, etc., to define what to negate.
• **Optimize for performance: Test queries, especially when using $not with regex or complex filters.
• **Keep queries simple: Avoid deeply nested $not conditions to reduce confusion and unexpected behavior.