$lte

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

$lte selects the documents where the value of thefield is less than or equal to (i.e. <=) the specifiedvalue.

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: { $lte: 20 } } )

This query will select all documents in the inventory collectionwhere the qty field value is less than or equal to 20.

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

  1. db.inventory.update( { "carrier.fee": { $lte: 5 } }, { $set: { price: 9.99 } } )

This update() operation will setthe price field value in the documents that contain the embeddeddocument carrier whose fee field value is less than or equalto 5.

See also

find(), update(), $set.