Comparison operators

javascript

db.orders.find({ total: { $gte: 100, $lte: 500 } })

Explanation

Range filters are common for prices, scores, and timestamps.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Filter patterns

Filter using `$in`.

Open In sheetjavascriptsame section

Match one of several conditions.

Open In sheetjavascriptsame section

Find documents that have or do not have a field.

Open In sheetjavascriptsame section

Search string values with a regular expression.

Open In sheetjavascriptsame section

Return only specific fields from matches.

Open In sheetjavascript1 tag match

Sort descending on a field.

Open In sheetjavascript1 tag match