Why logical operators matter in MongoDB

Introduction

Logical operators help you combine multiple conditions to find exactly what you want in your data.

You want to find documents that match several conditions at the same time.

You want to find documents that match at least one of several conditions.

You want to exclude documents that meet certain conditions.

You want to create complex filters by mixing conditions with AND, OR, and NOT.

You want to make your searches more precise and flexible.

Syntax

MongoDB

{ $and: [ { condition1 }, { condition2 } ] }
{ $or: [ { condition1 }, { condition2 } ] }
{ $not: { condition } }

$and means all conditions must be true.

$or means at least one condition must be true.

$not means the condition must NOT be true.

Examples

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

MongoDB

{ $and: [ { age: { $gt: 18 } }, { city: 'New York' } ] }

Finds documents where status is active OR score is at least 90.

MongoDB

{ $or: [ { status: 'active' }, { score: { $gte: 90 } } ] }

Finds documents where age is NOT less than 18.

MongoDB

{ age: { $not: { $lt: 18 } } }

Sample Program

This query finds students who have grade 'A' AND attendance of 90 or more.

MongoDB

db.students.find({ $and: [ { grade: 'A' }, { attendance: { $gte: 90 } } ] })

Important Notes

Logical operators can be combined to build complex queries.

Using them correctly helps you get precise results and saves time.

Summary

Logical operators combine conditions to filter data.

$and requires all conditions to be true.

$or requires at least one condition to be true.

$not excludes documents matching a condition.

Practice

1. Which logical operator in MongoDB requires all conditions to be true for a document to match?

easy

A. $and

B. $or

C. $not

D. $nor

Solution

1. Step 1: Recall MongoDB logical operators

   $and combines multiple conditions and only matches documents where every condition is true. $or matches if any condition is true, $not excludes matches, and $nor matches if none are true.

2. Final Answer:

   $and -> Option A

3. Quick Check:

   $and requires all true [OK]

Hint: Remember $and means all conditions must be true [OK]

Common Mistakes:

• Confusing $and with $or
• Thinking $not means all true
• Mixing $nor with $and

2. Which of the following is the correct syntax to find documents where age is greater than 25 or status is "active" in MongoDB?

easy

A. { $and: [ { age: { $gt: 25 } }, { status: "active" } ] }

B. { $nor: [ { age: { $gt: 25 } }, { status: "active" } ] }

C. { $not: [ { age: { $gt: 25 } }, { status: "active" } ] }

D. { $or: [ { age: { $gt: 25 } }, { status: "active" } ] }

Solution

1. Step 1: Identify $or operator and verify syntax

   $or matches documents where at least one condition is true, perfect for age > 25 or status = "active". The syntax with $or and array of conditions is correct; $and requires both true, $not and $nor have different meanings.

2. Final Answer:

   { $or: [ { age: { $gt: 25 } }, { status: "active" } ] } -> Option D

3. Quick Check:

   $or for either condition true = { $or: [ { age: { $gt: 25 } }, { status: "active" } ] } [OK]

Hint: Use $or for any condition true, syntax needs array [OK]

Common Mistakes:

• Using $and instead of $or
• Wrong array brackets
• Using $not with array incorrectly

3. Given the collection documents:
{ name: "Alice", age: 30, status: "active" }
{ name: "Bob", age: 20, status: "inactive" }
{ name: "Carol", age: 25, status: "active" }
What will the query { $and: [ { age: { $gt: 20 } }, { status: "active" } ] } return?

medium

A. [{ name: "Bob", age: 20, status: "inactive" }]

B. [{ name: "Alice", age: 30, status: "active" }, { name: "Carol", age: 25, status: "active" }]

C. [{ name: "Alice", age: 30, status: "active" }]

D. []

Solution

1. Step 1: Evaluate documents against $and conditions

   age > 20 and status = "active": Alice (30, active) matches, Carol (25, active) matches, Bob (20, inactive) does not. Both Alice and Carol returned.

2. Final Answer:

   [{ name: "Alice", age: 30, status: "active" }, { name: "Carol", age: 25, status: "active" }] -> Option B

3. Quick Check:

   Both age > 20 and active status = [{ name: "Alice", age: 30, status: "active" }, { name: "Carol", age: 25, status: "active" }] [OK]

Hint: Check each condition carefully for all documents [OK]

Common Mistakes:

• Including Bob who fails conditions
• Returning only one document
• Confusing $and with $or results

4. You wrote this query to exclude documents where status is "inactive":
{ $not: { status: "inactive" } }
But it returns an error. What is the problem?

medium

A. $not must be inside $and

B. $not cannot be used with strings

C. $not requires a condition operator like $eq, not a direct value

D. $not only works with numeric fields

Solution

1. Step 1: Identify $not syntax error

   $not expects a condition operator like { status: { $not: { $eq: "inactive" } } }, not { $not: { status: "inactive" } } with direct value.

2. Final Answer:

   $not requires a condition operator like $eq, not a direct value -> Option C

3. Quick Check:

   $not needs operator condition [OK]

Hint: Use $not with operators like $eq, not direct values [OK]

Common Mistakes:

• Passing direct values to $not
• Assuming $not works alone
• Using $not with arrays incorrectly

5. You want to find documents where age is greater than 20 but NOT with status equal to "inactive". Which query correctly uses logical operators to achieve this?

hard

A. { $and: [ { age: { $gt: 20 } }, { status: { $ne: "inactive" } } ] }

B. { $and: [ { age: { $gt: 20 } }, { $not: { status: { $eq: "inactive" } } } ] }

C. { $or: [ { age: { $gt: 20 } }, { $not: { status: { $eq: "inactive" } } } ] }

D. { $and: [ { age: { $gt: 20 } }, { $not: { status: "inactive" } } ] }

Solution

1. Step 1: Analyze requirement and options

   Need age > 20 AND status != "inactive". A: $not with direct value (invalid). B: $not wrongly placed at top-level; must be { status: { $not: { $eq: "inactive" } } } (but $ne simpler). C: $or allows documents failing one condition. D: Correctly uses $and with $gt and $ne.

2. Final Answer:

   { $and: [ { age: { $gt: 20 } }, { status: { $ne: "inactive" } } ] } -> Option A

3. Quick Check:

   Use $ne for NOT equal, combine with $and = { $and: [ { age: { $gt: 20 } }, { status: { $ne: "inactive" } } ] } [OK]

Hint: Use $ne for NOT equal, combine with $and for all true [OK]

Common Mistakes:

• Using $not with direct value
• Using $or instead of $and
• Overcomplicating with $not and $eq