Comparison Query Predicate Operators
Comparison operators filter data based on value comparisons such as less than and greater than.
For comparison of different BSON type values, see the specified BSON comparison order.
Operator | Description |
|---|---|
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 if the value is not equal to any of a given list of values. |
Compatibility
You can use comparison 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