Reference >
Query, Update, Projection, and Aggregation Operators >
$gt

$gt¶

$gt¶

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:

copy

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.