- Reference >
- Operators >
- Query Modifiers >
- $min
$min¶
-
$min
¶ Specify a
$min
value to specify the inclusive lower bound for a specific index in order to constrain the results offind()
. Themongo
shell provides themin()
wrapper method:You can also specify the option with either of the two forms:
The
$min
specifies the lower bound for all keys of a specific index in order.Consider the following operations on a collection named
collection
that has an index{ age: 1 }
:These operations limit the query to those documents where the field
age
is at least20
using the index{ age: 1 }
.You can explicitly specify the corresponding index with
hint()
. Otherwise, MongoDB selects the index using the fields in theindexBounds
; however, if multiple indexes exist on same fields with different sort orders, the selection of the index may be ambiguous.Consider a collection named
collection
that has the following two indexes:Without explicitly using
hint()
, it is unclear which index the following operation will select:You can use
$min
in conjunction with$max
to limit results to a specific range for the same index, as in the following example: