Back to MongoDB HubInterview MongoDB

Nearby lessons

11 of 22
MongoDB - Find DocumentMongoDB - Comparison OperatorsMongoDB - Logical OperatorsMongoDB - Element OperatorsMongoDB - Aggregation Pipeline Operators

🧩 MongoDB: Logical Operators

MongoDB provides logical operators to combine multiple query conditions. These operators help in filtering documents based on multiple criteria using **AND**, **OR**, **NOR**, and **NOT** logic.

📚 Initial Data Setup

MongoDB Shell
NoSQL
Database
1db.students.insertMany([
2  { name: "Akshay Kumar", age: 23, city: "Hyderabad", class: "BCA" },
3  { name: "Rajesh Khanna", age: 24, city: "Delhi", class: "Btech" },
4  { name: "Shahid Kapoor", age: 20, city: "Mumbai", class: "BSc" },
5  { name: "John Abraham", age: 19, city: "Delhi", class: "BCA" },
6  { name: "Aamir Khan", age: 24, city: "Pune", class: "Btech" }
7]);
Query Result
JSON Output
✅ 5 student documents inserted successfully.

1️⃣ Using $and — Logical AND

MongoDB Shell
NoSQL
Database
1db.students.find({ 
2  $and: [ { age: { $lt: 20 } }, { city: "Delhi" } ] 
3});
Query Result
JSON Output
[
  { name: "John Abraham", age: 19, city: "Delhi", class: "BCA" }
]

2️⃣ Using $or — Logical OR

MongoDB Shell
NoSQL
Database
1db.students.find({ 
2  $or: [ { age: { $lt: 20 } }, { city: "Delhi" } ] 
3});
Query Result
JSON Output
[
  { name: "John Abraham", age: 19, city: "Delhi", class: "BCA" },
  { name: "Rajesh Khanna", age: 24, city: "Delhi", class: "Btech" }
]

3️⃣ Using $nor — Logical NOR

MongoDB Shell
NoSQL
Database
1db.students.find({ 
2  $nor: [ { age: { $lt: 20 } }, { city: "Delhi" } ] 
3});
Query Result
JSON Output
[
  { name: "Shahid Kapoor", age: 20, city: "Mumbai", class: "BSc" },
  { name: "Aamir Khan", age: 24, city: "Pune", class: "Btech" },
  { name: "Akshay Kumar", age: 23, city: "Hyderabad", class: "BCA" }
]

4️⃣ Using $not — Logical NOT

MongoDB Shell
NoSQL
Database
1db.students.find({ 
2  age: { $not: { $lt: 20 } } 
3});
Query Result
JSON Output
[
  { name: "Shahid Kapoor", age: 20, city: "Mumbai", class: "BSc" },
  { name: "Aamir Khan", age: 24, city: "Pune", class: "Btech" },
  { name: "Akshay Kumar", age: 23, city: "Hyderabad", class: "BCA" },
  { name: "Rajesh Khanna", age: 24, city: "Delhi", class: "Btech" }
]
Keep Going!MongoDB - Element Operators