This version of the documentation is archived and no longer supported.



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

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

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 which 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 documents that contain the embedded document carrier whose fee field value is greater than 2.

See also

find(), update(), $set.

←   $exists $gte  →