javascriptANYmongodbquerycomparison
javascript
db.orders.find({ total: { $gte: 100, $lte: 500 } })Range filters are common for prices, scores, and timestamps.
MongoDB Queries, Projection, Sort, and Pagination
Use filters, logical operators, projections, sorting, skip, and limit to shape query results efficiently.
Export
Copy the compact sheet, download it, or print it.
Download
`D` dense toggle · `C` copy all
Filter patterns
Common selectors for exact matches and operator-based filtering.
javascriptANYmongodbqueryin
javascript
db.orders.find({ status: { $in: ["paid", "shipped"] } })Useful for dashboard queries and status subsets.
javascriptANYmongodbqueryor
javascript
db.orders.find({ $or: [{ priority: "high" }, { total: { $gt: 1000 } }] })Logical operators help express more realistic query conditions.
javascriptANYmongodbexistsquery
javascript
db.orders.find({ shipped_at: { $exists: false } })Helpful when auditing incomplete data or backfills.
javascriptANYmongodbregexquery
javascript
db.users.find({ email: /@example\.com$/i })Regex is flexible but can be expensive without the right patterns and indexes.
Projection, sort, and page
Return only the fields you need and keep results stable.
javascriptANYmongodbprojectionfind
javascript
db.users.find({ active: true }, { name: 1, email: 1, _id: 0 })Projection can reduce payload size and improve clarity.
javascriptANYmongodbsort
javascript
db.orders.find().sort({ created_at: -1 })`-1` is descending and `1` is ascending.
javascriptANYmongodblimit
javascript
db.orders.find().sort({ created_at: -1 }).limit(20)Limit is a basic building block for API endpoints and dashboards.
javascriptANYmongodbpaginationskiplimit
javascript
db.orders.find().sort({ created_at: -1 }).skip(40).limit(20)Offset pagination is easy to understand but can become less efficient for very large offsets.
javascriptANYmongodbpaginationcursor
javascript
db.orders.find({ _id: { $lt: ObjectId("65f0c8d4d95f1b2a3c4d5e6f") } }).sort({ _id: -1 }).limit(20)Cursor pagination usually scales better than repeated large skips.
More in MongoDB
MongoDB Transactions and Change Streams
Use sessions, multi-document transactions, and change streams for modern event-driven and consistency-sensitive MongoDB applications.
MongoDB Backup, Restore, and Replica Set Workflows
Use mongodump, mongorestore, replica set commands, and diagnostic tools for operational MongoDB workflows.
MongoDB Import, Export, and Database Tools
Use mongoimport, mongoexport, bsondump, and GridFS tools for practical MongoDB data movement workflows.
MongoDB Users, Roles, and Administrative Commands
Create users, grant roles, inspect server status, and run the most common administrative commands in MongoDB.
MongoDB Indexes, Explain Plans, and Performance
Create indexes, inspect query plans, and troubleshoot common MongoDB query performance issues.
MongoDB Aggregation Pipeline Patterns
Group, project, sort, unwind, lookup, facet, and aggregate analytics data with MongoDB pipelines.