$gt
$gt
selects those documents where the value of thefield
is greater than (i.e. >
) the specified 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: { $gt: 20 } } )
This query will select all documents in the inventory
collectionwhere the qty
field value is greater than 20
.
Consider the following example that uses the $gt
operator with a field from an embedded document:
- db.inventory.update( { "carrier.fee": { $gt: 2 } }, { $set: { price: 9.99 } } )
This update()
operation will setthe value of the price
field in the first document found containing theembedded document carrier
whose fee
field value isgreater than 2
.
To set the value of the price
field in all documents containing theembedded document carrier
whose fee
field value is greater than 2
,specify the multi:true
option in the update()
method:
- db.inventory.update(
- { "carrier.fee": { $gt: 2 } },
- { $set: { price: 9.99 } },
- { multi: true }
- )
See also