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

$gte

$gte

Syntax: {field: {$gte: value} }

$gte selects the documents where the value of the field is greater than or equal to (i.e. >=) a specified value (e.g. value.)

For comparison of different BSON type values, see the specified BSON comparison order.

Consider the following example:

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

This query would select all documents in inventory where the qty field value is greater than or equal to 20.

Consider the following example which uses the $gte operator with a field from an embedded document:

db.inventory.update( { "carrier.fee": { $gte: 2 } }, { $set: { price: 9.99 } } )

This update() operation will set the value of the price field that contain the embedded document carrier whose fee field value is greater than or equal to 2.

See also

find(), update(), $set.

←   $gt $lt  →