Docs Menu
Docs Home
/
MongoDB Manual
/ /

Query and Projection Operators

On this page

  • Compatibility
  • Query Selectors
  • Projection Operators
  • Miscellaneous Operators

Note

For details on a specific operator, including syntax and examples, click on the link to the operator's reference page.

You can use query and projection operators for deployments hosted in the following environments:

  • MongoDB Atlas: The fully managed service for MongoDB deployments in the cloud

  • MongoDB Enterprise: The subscription-based, self-managed version of MongoDB

  • MongoDB Community: The source-available, free-to-use, and self-managed version of MongoDB

For comparison of different BSON type values, see the specified BSON comparison order.

Name
Description
$eq
Matches values that are equal to a specified value.
Matches values that are greater than a specified value.
Matches values that are greater than or equal to a specified value.
Matches any of the values specified in an array.
Matches values that are less than a specified value.
Matches values that are less than or equal to a specified value.
Matches all values that are not equal to a specified value.
Matches none of the values specified in an array.
Name
Description
Joins query clauses with a logical AND returns all documents that match the conditions of both clauses.
Inverts the effect of a query expression and returns documents that do not match the query expression.
Joins query clauses with a logical NOR returns all documents that fail to match both clauses.
Joins query clauses with a logical OR returns all documents that match the conditions of either clause.
Name
Description
Matches documents that have the specified field.
Selects documents if a field is of the specified type.
Name
Description
Allows use of aggregation expressions within the query language.
Validate documents against the given JSON Schema.
Performs a modulo operation on the value of a field and selects documents with a specified result.
Selects documents where values match a specified regular expression.

Performs text search.

Note

$text provides text query capabilities for self-managed (non-Atlas) deployments. For data hosted on MongoDB Atlas, MongoDB offers an improved full-text query solution, Atlas Search.

Matches documents that satisfy a JavaScript expression.
Name
Description
Selects geometries that intersect with a GeoJSON geometry. The 2dsphere index supports $geoIntersects.
Selects geometries within a bounding GeoJSON geometry. The 2dsphere and 2d indexes support $geoWithin.
Returns geospatial objects in proximity to a point. Requires a geospatial index. The 2dsphere and 2d indexes support $near.
Returns geospatial objects in proximity to a point on a sphere. Requires a geospatial index. The 2dsphere and 2d indexes support $nearSphere.
Name
Description
Matches arrays that contain all elements specified in the query.
Selects documents if element in the array field matches all the specified $elemMatch conditions.
Selects documents if the array field is a specified size.
Name
Description
Matches numeric or binary values in which a set of bit positions all have a value of 0.
Matches numeric or binary values in which a set of bit positions all have a value of 1.
Matches numeric or binary values in which any bit from a set of bit positions has a value of 0.
Matches numeric or binary values in which any bit from a set of bit positions has a value of 1.
Name
Description
Projects the first element in an array that matches the query condition.
Projects the first element in an array that matches the specified $elemMatch condition.

Projects the document's score assigned during the $text operation.

Note

$text provides text query capabilities for self-managed (non-Atlas) deployments. For data hosted on MongoDB Atlas, MongoDB offers an improved full-text query solution, Atlas Search.

Limits the number of elements projected from an array. Supports skip and limit slices.
Name
Description
Adds a comment to a query predicate.
Generates a random float between 0 and 1.

Back

Operators

Next

Comparison Query Operators