DocumentDB LogoDocumentDB
HomeGitHubDiscordDocsBlogs
Back to DocumentationMQL Documentation
CommandsAggregationQuery And Write
OperatorsAccumulatorAggregationArithmetic ExpressionArray ExpressionArray QueryArray UpdateBitwiseBitwise QueryBitwise UpdateBoolean ExpressionComparison QueryConditional ExpressionData SizeDate ExpressionElement QueryEvaluation QueryField UpdateGeospatialLogical QueryMiscellaneousObject ExpressionProjectionSet ExpressionTimestamp ExpressionVariable ExpressionWindow
Reference/Operators/Comparison Query

MongoDB Query Language (MQL) Comparison Query Operators

$cmp

The `$cmp` operator compares two specified values. The $cmp operator returns -1 if the first value is less than the second, 0 if the two values are equal and 1 if the first value is greater than the second.

$eq

The `$eq` operator is used to match documents where the value of a field is equal to a specified value.

$gt

The `$gt` operator retrieves documents where the value of a field is greater than a specified value.

$gte

The `$gte` operator retrieves documents where the value of a field is greater than or equal to a specified value.

$in

The `$in` operator matches values of a field against an array of possible values.

$lt

The `$lt` operator retrieves documents where the value of a field is strictly less than a specified value.

$lte

The `$lte` operator retrieves documents where the value of a field is less than or equal to a specified value.

$ne

The `$ne` operator retrieves documents where the value of a field doesn't equal a specified value.

$nin

The `$nin` operator retrieves documents where the value of a specified field doesn't match any value in a list.

Copyright © DocumentDB a Series of LF Projects, LLC. For web site terms of use, trademark policy and other project policies please see https://lfprojects.org.