Comparison Operators

These operators allow to match based on a fields value relative to some other value.

📌 $gt, $lt

db.movieDetails.find({“runtime”: {$gt: 90, $lt: 120}})

You can also add more than one filter.

db.movieDetails.find({“runtime”: {$gt: 90, $lt: 120}, “tomato.meter”: {$gte: 95}})

📌 $ne

Values that are not equal to some specific value.

db.movieDetails.find({“rated”: {$ne: “UNRATED”}})

📌 $in

Allows to specify one or more values. This filter will look to match any value that is defined in the array value.

db.movieDetails.find({“rated”: {$in: [“G”, “PG”]}})

$nin does the opposite operation to $in

Last updated

Was this helpful?