翻译或纠错本页面
Query and Projection Operators¶
Query Selectors¶
Comparison¶
For comparison of different BSON type values, see the specified BSON comparison order.
Name | Description |
---|---|
$gt | Matches values that are greater than the value specified in the query. |
$gte | Matches values that are greater than or equal to the value specified in the query. |
$lt | Matches values 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. |
$in | Matches any of the values that exist in an array specified in the query. |
$nin | Matches values that do not exist in an array specified to the query. |
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. |
Element¶
Name | Description |
---|---|
$exists | Matches documents that have the specified field. |
$type | Selects documents if a field is of the specified type. |
Evaluation¶
Name | Description |
---|---|
$mod | Performs a modulo operation on the value of a field and selects documents with a specified result. |
$regex | Selects documents where values match a specified regular expression. |
$text | Performs text search. |
$where | Matches documents that satisfy a JavaScript expression. |
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. |
Array¶
Name | Description |
---|---|
$all | Matches arrays that contain all elements specified in the query. |
$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. |
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. |
$meta | Projects the document’s score assigned during $text operation. |
$slice | Limits the number of elements projected from an array. Supports skip and limit slices. |