MongoDB using NOT and AND together

In MongoDB, to handle query conditions involving both $not and $and operators, we can use the $not and $and operators. The $not operator negates a query condition, while the $and operator combines multiple query conditions to ensure all are satisfied.

Here, I provide a specific example to illustrate how to apply these operators:

Suppose we have a user document collection, where each document records the user's name (name), age (age), and job (job). Now, we want to find all users whose age is at least 25 years old and whose job is not 'programmer'.

We can use the following query:

json
{
  "$and": [
    { "age": { "$gte": 25 } },
    { "job": { "$not": { "$eq": "programmer" } } }
  ]
}

In this query:

• "$gte": 25 ensures that the matched documents have an age of at least 25 years old.
• "$not": { "$eq": "programmer" } ensures that the matched documents have a job not equal to 'programmer'.
• "$and" ensures that both conditions must be satisfied simultaneously.

Using such a query, MongoDB returns all user documents where the age is at least 25 years old and the job is not 'programmer'. This combination of using $not and $and is highly useful for flexibly handling more complex logical condition combinations.