• Reference >
• Query, Update and Projection Operators

Query, Update and Projection Operators

Query Selectors

Comparison

Name	Description
$all	Matches arrays that contain all elements specified in the query.
$gt	Matches values that are greater than the value specified in the query.
$gte	Matches values that are equal to or greater than the value specified in the query.
$in	Matches any of the values that exist in an array specified in the query.
$lt	Matches vales that are less than the value specified in the query.
$lte	Matches values that are less than or equal to the value specified in the query.
$ne	Matches all values that are not equal to the value specified in the query.
$nin	Matches values that do not exist in an array specified to the query.

• Comparison Query Operators
  • $all
  • $gt
  • $gte
  • $in
  • $lt
  • $lte
  • $ne
  • $nin

Logical

Name	Description
$or	Joins query clauses with a logical OR returns all documents that match the conditions of either clause.
$and	Joins query clauses with a logical AND returns all documents that match the conditions of both clauses.
$not	Inverts the effect of a query expression and returns documents that do not match the query expression.
$nor	Joins query clauses with a logical NOR returns all documents that fail to match both clauses.

• Logical Query Operators
  • $or
  • $and
  • $not
  • $nor

Element

Name	Description
$exists	Matches documents that have the specified field.
$mod	Performs a modulo operation on the value of a field and selects documents with a specified result.
$type	Selects documents if a field is of the specified type.

• Element Query Operators
  • $exists
  • $mod
  • $type

JavaScript

Name	Description
$where	Matches documents that satisfy a JavaScript expression.
$regex	Selects documents where values match a specified regular expression.

• JavaScript Query Operators
  • $where
  • $regex

Geospatial

Name	Description
$geoWithin	Selects geometries within a bounding GeoJSON geometry.
$geoIntersects	Selects geometries that intersect with a GeoJSON geometry.
$near	Returns geospatial objects in proximity to a point.
$nearSphere	Returns geospatial objects in proximity to a point on a sphere.

• Geospatial Query Operators
  • $geoWithin
  • $geoIntersects
  • $near
  • $nearSphere

Array

Name	Description
$elemMatch	Selects documents if element in the array field matches all the specified $elemMatch condition.
$size	Selects documents if the array field is a specified size.

• Query Operator Array
  • $elemMatch (query)
  • $size

Update Operators

Fields

Name	Description
$inc	Increments the value of the field by the specified amount.
$rename	Renames a field.
$setOnInsert	Sets the value of a field upon documentation creation during an upsert. Has no effect on update operations that modify existing documents.
$set	Sets the value of a field in an existing document.
$unset	Removes the specified field from an existing document.

• Field Update Operators
  • $inc
  • $rename
  • $setOnInsert
  • $set
  • $unset

Array

Operators

Name	Description
$	Acts as a placeholder to update the first element that matches the query condition in an update.
$addToSet	Adds elements to an existing array only if they do not already exist in the set.
$pop	Removes the first or last item of an array.
$pullAll	Removes multiple values from an array.
$pull	Removes items from an array that match a query statement.
$pushAll	Deprecated. Adds several items to an array.
$push	Adds an item to an array.

Modifiers

Name	Description
$each	Modifies the $push and $addToSet operators to append multiple items for array updates.
$slice	Modifies the $push operator to limit the size of updated arrays.
$sort	Modifies the $push operator to reorder documents stored in an array.

• Array Update Operators
  • $ (query)
  • $addToSet
  • $pop
  • $pullAll
  • $pull
  • $pushAll
  • $push
  • $each
  • $slice
  • $sort

Bitwise

Name	Description
$bit	Performs bitwise AND and OR updates of integer values.

• Bitwise Update Operator
  • $bit

Isolation

Name	Description
$isolated	Modifies behavior of multi-updates to improve the isolation of the operation.

• Isolation Update Operator
  • $isolated

Projection Operators

Name	Description
$	Projects the first element in an array that matches the query condition.
$elemMatch	Projects only the first element from an array that matches the specified $elemMatch condition.
$slice	Limits the number of elements projected from an array. Supports skip and limit slices.

• Projection Operators
  • $ (projection)
  • $elemMatch (projection)
  • $slice (projection)

Projection Operators

Name	Description
$comment	Adds a comment to the query to identify queries in the database profiler output.
$explain	Forces MongoDB to report on query execution plans. See explain().
$hint	Forces MongoDB to use a specific index. See hint()
$maxScan	Limits the number of documents a cursor will return for a query. See limit().
$max	Specifies a minimum exclusive upper limit for the index to use in a query. See max().
$min	Specifies a minimum inclusive lower limit for the index to use in a query. See min().
$orderby	Returns a cursor with documents sorted according to a sort specification. See sort().
$returnKey	Forces the cursor to only return fields included in the index.
$showDiskLoc	Modifies the documents returned to include references to the on-disk location of each document.
$snapshot	Forces the query to use the index on the _id field. See snapshot().

• Meta Query Operator Quick Reference
  • $comment
  • $explain
  • $hint
  • $maxScan
  • $max
  • $min
  • $orderby
  • $returnKey
  • $showDiskLoc
  • $snapshot
  • $natural

• <   Reference
• /\  Reference
• Comparison Query Operators  >