$pull operator for removing from arrays in MongoDB - Mini Project: Build & Apply

$pull Operator to Remove Items from Arrays in MongoDB

📖 Scenario: You manage a MongoDB collection that stores information about a library's book catalog. Each book document has a list of genres it belongs to. Sometimes, you need to remove a specific genre from a book's list when it no longer fits.

🎯 Goal: Learn how to use the $pull operator in MongoDB to remove a specific item from an array field inside documents.

📋 What You'll Learn

Create a collection named books with one document containing a genres array

Define a variable with the genre name to remove

Use the $pull operator in an update query to remove the specified genre from the array

Verify the update query targets the correct document and field

💡 Why This Matters

🌍 Real World

Managing and updating array data in MongoDB documents is common in real-world applications like user preferences, tags, or categories.

💼 Career

Understanding how to modify arrays with $pull is essential for database administrators and backend developers working with MongoDB.

1

Create the books collection with one document

Create a collection called books and insert one document with title set to 'The Great Adventure' and genres array containing 'Fantasy', 'Adventure', and 'Action'.

MongoDB

// Insert the document into the books collection
// Your code here

Hint

Use db.books.insertOne() with an object containing title and genres array.

2

Define the genre to remove

Create a variable called genreToRemove and set it to the string 'Adventure'.

MongoDB

db.books.insertOne({ title: 'The Great Adventure', genres: ['Fantasy', 'Adventure', 'Action'] })

// Define the genre to remove
// Your code here

Hint

Use const genreToRemove = 'Adventure' to store the genre name.

3

Use $pull to remove the genre from the array

Write an update query using db.books.updateOne() to find the document with title equal to 'The Great Adventure' and use the $pull operator to remove the genre stored in genreToRemove from the genres array.

MongoDB

db.books.insertOne({ title: 'The Great Adventure', genres: ['Fantasy', 'Adventure', 'Action'] })

const genreToRemove = 'Adventure';

// Update the document to remove the genre
// Your code here

Hint

Use db.books.updateOne() with a filter on title and $pull to remove the genre.

4

Confirm the update query targets the correct document

Add a query to find the document with title equal to 'The Great Adventure' to verify the genres array no longer contains 'Adventure'.

MongoDB

db.books.insertOne({ title: 'The Great Adventure', genres: ['Fantasy', 'Adventure', 'Action'] })

const genreToRemove = 'Adventure';

db.books.updateOne({ title: 'The Great Adventure' }, { $pull: { genres: genreToRemove } })

// Find the updated document
// Your code here

Hint

Use db.books.findOne() with the filter on title to check the document.

Practice

1. What does the $pull operator do in MongoDB?

easy

A. Removes all array elements that match a specified condition.

B. Adds new elements to an array.

C. Replaces the entire array with a new one.

D. Sorts the elements inside an array.

Solution

1. Step 1: Understand the purpose of $pull

   The $pull operator is used to remove elements from an array that match a given condition.

2. Step 2: Compare with other array operators

   Unlike $push which adds elements, $pull removes matching elements without affecting others.

3. Final Answer:

   Removes all array elements that match a specified condition. -> Option A

4. Quick Check:

   $pull = Remove matching elements [OK]

Hint: Remember: $pull always removes matching array items [OK]

Common Mistakes:

• Confusing $pull with $push (which adds elements)
• Thinking $pull replaces the whole array
• Assuming $pull sorts or modifies elements

2. Which of the following is the correct syntax to remove the value 5 from the array field numbers in MongoDB?

easy

A. db.collection.updateOne({}, {$pull: {numbers: 5}})

B. db.collection.updateOne({}, {$pull: {numbers: {$ne: 5}}})

C. db.collection.updateOne({}, {$remove: {numbers: 5}})

D. db.collection.updateOne({}, {$pop: {numbers: 5}})

Solution

1. Step 1: Identify the correct operator and syntax

   The $pull operator removes elements matching the value directly, so {$pull: {numbers: 5}} is correct.

2. Step 2: Check other options for errors

   db.collection.updateOne({}, {$pop: {numbers: 5}}) uses $pop which only removes first/last elements. db.collection.updateOne({}, {$pull: {numbers: {$ne: 5}}}) uses {$ne: 5} inside $pull which removes non-matching elements. db.collection.updateOne({}, {$remove: {numbers: 5}}) uses invalid $remove operator.

3. Final Answer:

   db.collection.updateOne({}, {$pull: {numbers: 5}}) -> Option A

4. Quick Check:

   Simple value removal uses $pull: {field: value} [OK]

Hint: Use $pull: {field: value} to remove simple values [OK]

Common Mistakes:

• Using $remove instead of $pull
• Using $pop which removes first or last element only
• Adding unnecessary query operators for simple values

3. Given the document { _id: 1, tags: ["red", "blue", "green", "blue"] }, what will be the tags array after running db.collection.updateOne({_id: 1}, {$pull: {tags: "blue"}})?

medium

A. ["blue", "blue"]

B. ["red", "blue", "green"]

C. ["red", "green", "blue"]

D. ["red", "green"]

Solution

1. Step 1: Understand $pull removes all matching elements

   The $pull operator removes every element equal to "blue" from the array.

2. Step 2: Remove all "blue" elements from the array

   Original array: ["red", "blue", "green", "blue"]. After removal: ["red", "green"] because both "blue" elements are removed.

3. Final Answer:

   ["red", "green"] -> Option D

4. Quick Check:

   All "blue" removed = ["red", "green"] [OK]

Hint: Remember $pull removes all matching elements, not just one [OK]

Common Mistakes:

• Removing only the first matching element
• Leaving one "blue" element by mistake
• Confusing $pull with $pop or $pullAll

4. You want to remove all numbers less than 10 from the array field scores. Which of the following update commands will NOT work correctly?

medium

A. db.collection.updateOne({}, {$pull: {scores: { $lt: 10 }}})

B. db.collection.updateOne({}, {$pull: {scores: {$lt: 10}}})

C. db.collection.updateOne({}, {$pull: {scores: { $gte: 10 }}})

D. db.collection.updateOne({}, {$pull: {scores: {$lt:10}}})

Solution

1. Step 1: Understand the condition to remove numbers less than 10

   The correct condition is {$lt: 10} to remove numbers less than 10.

2. Step 2: Analyze each option

   Options B, C, and D use {$lt: 10} correctly. db.collection.updateOne({}, {$pull: {scores: { $gte: 10 }}}) uses {$gte: 10}, which removes numbers greater than or equal to 10, the opposite of the goal.

3. Final Answer:

   db.collection.updateOne({}, {$pull: {scores: { $gte: 10 }}}) -> Option C

4. Quick Check:

   Use $lt to remove less than 10, not $gte [OK]

Hint: Use correct comparison operator inside $pull condition [OK]

Common Mistakes:

• Using wrong comparison operator ($gte instead of $lt)
• Confusing $pull condition syntax
• Repeating same option without change (typo)

5. Consider documents with a field items containing objects like {name: "apple", qty: 5}. How would you remove all items where qty is 0 using $pull?

hard

A. db.collection.updateMany({}, {$pull: {items: {qty: {$ne: 0}}}})

B. db.collection.updateMany({}, {$pull: {items: {qty: 0}}})

C. db.collection.updateMany({}, {$pull: {items: {name: "apple"}}})

D. db.collection.updateMany({}, {$pull: {items: {qty: {$gt: 0}}}})

Solution

1. Step 1: Identify the condition to remove items with qty 0

   We want to remove array elements where the field qty equals 0.

2. Step 2: Use $pull with a query object matching qty: 0

   The correct syntax is {$pull: {items: {qty: 0}}} which removes all objects with qty 0.

3. Final Answer:

   db.collection.updateMany({}, {$pull: {items: {qty: 0}}}) -> Option B

4. Quick Check:

   Match exact condition inside $pull to remove objects [OK]

Hint: Use $pull with object condition to remove matching objects [OK]

Common Mistakes:

• Removing by wrong field (like name instead of qty)
• Using $ne or $gt incorrectly inside $pull
• Confusing $pull with $push or $pop