$gt

  • $gt
    • Syntax : {field: {$gt: value} }

$gt selects those documents where the value of the field is greater than (i.e. > ) the specified value .

For most data types, comparison operators only perform comparisons on fields where the BSON type matches the query value’s type. MongoDB supports limited cross-BSON comparison through Type Bracketing.

Consider the following example:

db.inventory.find( { qty: { $gt: 20 } } )

This query will select all documents in the inventory collection where 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 set the value of the price field in the first document found containing the embedded document carrier whose fee field value is greater than 2 .

To set the value of the price field in all documents containing the embedded 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