$gte
$gte
selects the documents where the value of thefield
is greater than or equal to (i.e. >=
) a specifiedvalue (e.g. value
.)
For most data types, comparisonoperators only performcomparisons on fields where theBSON type matches thequery value’s type. MongoDB supports limited cross-BSON comparisonthrough Type Bracketing.
Consider the following example:
- db.inventory.find( { qty: { $gte: 20 } } )
This query would select all documents in inventory
wherethe qty
field value is greater than or equal to 20
.
Consider the following example which uses the $gte
operator with a field from an embedded document:
- db.inventory.update( { "carrier.fee": { $gte: 2 } }, { $set: { price: 9.99 } } )
This update()
operation will setthe value of the price
field that contain the embedded documentcarrier
whose fee
field value is greater than or equal to2
.
See also