Skip to content

Comparison Operator

  1. $eq
  2. $ne
  3. $gt
  4. $gte
  5. $lt
  6. $lte
  7. $in
  8. $nin

  9. Find products whose price is equals to 699

db.products.find({price: {$eq: 699}})
  • Find products whose price is in given array
shop> db.products.find({price: {$in: [249,129,39]}})
  • Multiple comparison operators
shop> db.products.find({price: {$in: [249,129,39]}, colors: {$in:['#ffffff']}})