• Reference >
• Operators

Operators

Query and Projection Operators

Query operators provide ways to locate data within the database and projection operators modify how data is presented.

Update Operators

Update operators are operators that enable you to modify the data in your database or add additional data.

Aggregation Pipeline Operators

Aggregation pipeline operations have a collection of operators available to define and manipulate documents in pipeline stages.

• Query and Projection Operators
  • Comparison Query Operators
    • $eq
    • $gt
    • $gte
    • $lt
    • $lte
    • $ne
    • $in
    • $nin
  • Logical Query Operators
    • $or
    • $and
    • $not
    • $nor
  • Element Query Operators
    • $exists
    • $type
  • Evaluation Query Operators
    • $mod
    • $regex
    • $text
    • $where
  • Geospatial Query Operators
    • $geoWithin
    • $geoIntersects
    • $near
    • $nearSphere
    • $geometry
    • $minDistance
    • $maxDistance
    • $center
    • $centerSphere
    • $box
    • $polygon
    • $uniqueDocs
  • Query Operator Array
    • $all
    • $elemMatch (query)
    • $size
  • Bitwise Query Operators
    • $bitsAllSet
    • $bitsAnySet
    • $bitsAllClear
    • $bitsAnyClear
  • $comment
  • Projection Operators
    • $ (projection)
    • $elemMatch (projection)
    • $meta
    • $slice (projection)
• Update Operators
  • Field Update Operators
    • $inc
    • $mul
    • $rename
    • $setOnInsert
    • $set
    • $unset
    • $min
    • $max
    • $currentDate
  • Array Update Operators
    • $ (update)
    • $addToSet
    • $pop
    • $pullAll
    • $pull
    • $pushAll
    • $push
    • $each
    • $slice
    • $sort
    • $position
  • Bitwise Update Operator
    • $bit
  • Isolation Update Operator
    • $isolated
• Aggregation Pipeline Operators
  • Pipeline Aggregation Stages
    • $project (aggregation)
    • $match (aggregation)
    • $redact (aggregation)
    • $limit (aggregation)
    • $skip (aggregation)
    • $unwind (aggregation)
    • $group (aggregation)
    • $sample (aggregation)
    • $sort (aggregation)
    • $geoNear (aggregation)
    • $lookup (aggregation)
    • $out (aggregation)
    • $indexStats (aggregation)
  • Boolean Aggregation Operators
    • $and (aggregation)
    • $or (aggregation)
    • $not (aggregation)
  • Set Operators (Aggregation)
    • $setEquals (aggregation)
    • $setIntersection (aggregation)
    • $setUnion (aggregation)
    • $setDifference (aggregation)
    • $setIsSubset (aggregation)
    • $anyElementTrue (aggregation)
    • $allElementsTrue (aggregation)
  • Comparison Aggregation Operators
    • $cmp (aggregation)
    • $eq (aggregation)
    • $gt (aggregation)
    • $gte (aggregation)
    • $lt (aggregation)
    • $lte (aggregation)
    • $ne (aggregation)
  • Arithmetic Aggregation Operators
    • $abs (aggregation)
    • $add (aggregation)
    • $ceil (aggregation)
    • $divide (aggregation)
    • $exp (aggregation)
    • $floor (aggregation)
    • $ln (aggregation)
    • $log (aggregation)
    • $log10 (aggregation)
    • $mod (aggregation)
    • $multiply (aggregation)
    • $pow (aggregation)
    • $sqrt (aggregation)
    • $subtract (aggregation)
    • $trunc (aggregation)
  • String Aggregation Operators
    • $concat (aggregation)
    • $substr (aggregation)
    • $toLower (aggregation)
    • $toUpper (aggregation)
    • $strcasecmp (aggregation)
  • Text Search Aggregation Operators
    • $meta (aggregation)
  • Array Aggregation Operators
    • $arrayElemAt (aggregation)
    • $concatArrays (aggregation)
    • $filter (aggregation)
    • $isArray (aggregation)
    • $size (aggregation)
    • $slice (aggregation)
  • Aggregation Variable Operators
    • $map (aggregation)
    • $let (aggregation)
  • Aggregation Literal Operators
    • $literal (aggregation)
  • Date Aggregation Operators
    • $dayOfYear (aggregation)
    • $dayOfMonth (aggregation)
    • $dayOfWeek (aggregation)
    • $year (aggregation)
    • $month (aggregation)
    • $week (aggregation)
    • $hour (aggregation)
    • $minute (aggregation)
    • $second (aggregation)
    • $millisecond (aggregation)
    • $dateToString (aggregation)
  • Conditional Aggregation Operators
    • $cond (aggregation)
    • $ifNull (aggregation)
  • Group Accumulator Operators
    • $sum (aggregation)
    • $avg (aggregation)
    • $first (aggregation)
    • $last (aggregation)
    • $max (aggregation)
    • $min (aggregation)
    • $push (aggregation)
    • $addToSet (aggregation)
    • $stdDevPop (aggregation)
    • $stdDevSamp (aggregation)

←   Reference Query and Projection Operators  →

Was this page helpful?

Yes No

Thank you for your feedback!

We're sorry! You can Report a Problem to help us improve this page.

© MongoDB, Inc 2008-2016. MongoDB, Mongo, and the leaf logo are registered trademarks of MongoDB, Inc.