MongoDB — Logical Operators

AND

db.users.find({ $and: [{ age: { $gt: 18 } }, { active: true }] })

OR

db.users.find({ $or: [{ country: "USA" }, { country: "UK" }] })

NOT

db.users.find({ age: { $not: { $gt: 30 } } })

NOR

db.users.find({ $nor: [{ age: { $lt: 18 } }, { active: false }] })

Implicit AND

// Multiple fields = AND
db.users.find({ age: { $gt: 18 }, active: true })

Combined

db.users.find({
  $and: [
    { $or: [{ country: "USA" }, { country: "UK" }] },
    { age: { $gte: 18 } }
  ]
})

Mini Practice

1. Use AND operator
2. Use OR operator
3. Use NOT operator
4. Combine logical operators

Up Next

Continue with Array Operators — array operators.