$gt

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

$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:

  1. 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 $gtoperator with a field from an embedded document:

  1. 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:

  1. db.inventory.update(
  2. { "carrier.fee": { $gt: 2 } },
  3. { $set: { price: 9.99 } },
  4. { multi: true }
  5. )

See also

find(), update(), $set.