$and operator behavior in MongoDB - Step-by-Step Execution

Concept Flow - $and operator behavior

Start Query

↓

Evaluate Each Condition

↓

Are All Conditions True?

No→Return No Match

Yes↓

Return Document Match

The $and operator checks multiple conditions and returns documents only if all conditions are true.

Execution Sample

MongoDB

{ $and: [ { age: { $gt: 20 } }, { city: 'NY' } ] }

Find documents where age is greater than 20 AND city is 'NY'.

Execution Table

Step	Document	Condition 1 (age > 20)	Condition 2 (city = 'NY')	All Conditions True?	Result
1	{ age: 25, city: 'NY' }	True	True	True	Match
2	{ age: 18, city: 'NY' }	False	True	False	No Match
3	{ age: 30, city: 'LA' }	True	False	False	No Match
4	{ age: 22, city: 'NY' }	True	True	True	Match
5	{ age: 20, city: 'NY' }	False	True	False	No Match

💡 All documents checked; only those with all conditions true are matched.

Variable Tracker

Document	Condition 1 (age > 20)	Condition 2 (city = 'NY')	All Conditions True?
{ age: 25, city: 'NY' }	True	True	True
{ age: 18, city: 'NY' }	False	True	False
{ age: 30, city: 'LA' }	True	False	False
{ age: 22, city: 'NY' }	True	True	True
{ age: 20, city: 'NY' }	False	True	False

Key Moments - 3 Insights

Why does a document with age 18 and city 'NY' not match?

Because the first condition (age > 20) is false for that document, so $and returns false overall (see execution_table row 2).

If one condition is false, does $and still return true?

No, $and requires all conditions to be true. If any condition is false, the whole $and is false (see execution_table rows 2, 3, and 5).

Can $and be used with just one condition?

Yes, but it behaves like that single condition alone. $and is useful when combining multiple conditions (not shown in table but general behavior).

Visual Quiz - 3 Questions

Look at the execution table, what is the result for the document { age: 30, city: 'LA' }?

A Match

B No Match

C Error

D Partial Match

💡 Hint

Check row 3 in the execution_table under 'Result' column.

At which step does the condition 'age > 20' become false?

A Step 2

B Step 4

C Step 1

D Step 3

💡 Hint

Look at the 'Condition 1 (age > 20)' column in execution_table.

If the second condition changed to city = 'LA', which document would match?

A { age: 25, city: 'NY' }

B { age: 18, city: 'NY' }

C { age: 30, city: 'LA' }

D { age: 22, city: 'NY' }

💡 Hint

Check which document has city 'LA' and age > 20 in variable_tracker.

Concept Snapshot

$and operator syntax:
{ $and: [ condition1, condition2, ... ] }
Returns documents only if ALL conditions are true.
If any condition is false, document is excluded.
Useful to combine multiple filters logically.

Full Transcript

The $and operator in MongoDB combines multiple conditions. It checks each condition on a document. If all conditions are true, the document matches. If any condition is false, the document does not match. For example, { $and: [ { age: { $gt: 20 } }, { city: 'NY' } ] } finds documents where age is greater than 20 and city is 'NY'. The execution table shows documents tested step-by-step, with condition results and final match decision. This helps beginners see how $and works internally.