Implicit AND with multiple conditions in MongoDB

Introduction

Implicit AND lets you find documents that match all your conditions without writing AND explicitly.

You want to find users who live in a specific city and are above a certain age.

You need to get products that are in stock and cost less than a certain price.

You want to search for books that are both fiction and published after 2010.

Syntax

MongoDB

{ field1: value1, field2: value2, ... }

All conditions inside the curly braces are combined with AND automatically.

You don't need to write $and explicitly unless you want to use complex conditions.

Examples

Finds documents where age is greater than 25 AND city is "New York".

MongoDB

{ age: { $gt: 25 }, city: "New York" }

Finds documents where status is "active" AND score is at least 80.

MongoDB

{ status: "active", score: { $gte: 80 } }

Sample Program

This query finds all users older than 30 who live in Chicago.

MongoDB

db.users.find({ age: { $gt: 30 }, city: "Chicago" })

Important Notes

If you want to combine conditions on the same field, you need to use $and explicitly.

Implicit AND works only at the top level of the query object.

Summary

Multiple conditions inside a query object are combined with AND automatically.

You don't need to write $and for simple AND queries.

Use implicit AND to write cleaner and easier-to-read queries.