How can I remove a field from every document in MongoDB?

How can I remove a field from every document in MongoDB?

MongoDB is a popular NoSQL database management system that stores data in a document-oriented format. In order to remove a field from every document in MongoDB, one can use the update() method with the $unset operator. This operator allows for the removal of a specific field from all documents within a collection. By specifying the field name and value as parameters, the update operation will remove the field from each document, effectively removing it from the entire collection. This method provides a quick and efficient way to remove unwanted fields from every document in MongoDB.

MongoDB: Remove a Field from Every Document


You can use the following methods to remove fields from every document in a collection in MongoDB:

Method 1: Remove One Field

db.collection.updateMany({}, {$unset: {"field1":1}})

Method 2: Remove Multiple Fields

db.collection.updateMany({}, {$unset: {"field1":1, "field2":1}})

The following examples show how to use each method with a collection teams with the following documents:

db.teams.insertOne({team: "Mavs", position: "Guard", points: 31})db.teams.insertOne({team: "Spurs", position: "Guard", points: 22})db.teams.insertOne({team: "Rockets", position: "Center", points: 19})

Example 1: Remove One Field

We can use the following code to remove the “points” field from every document in our collection:

db.teams.updateMany({}, {$unset: {"points":1}})

We can then use the following query to view each document in our collection:

db.teams.find()

This query returns the following results:

{ _id: ObjectId("61893b7196cd2ba58ce928f4"),
  team: 'Mavs',
  position: 'Guard' }

{ _id: ObjectId("61893b7196cd2ba58ce928f5"),
  team: 'Spurs',
  position: 'Guard' }

{ _id: ObjectId("61893b7196cd2ba58ce928f6"),
  team: 'Rockets',
  position: 'Center' }

Notice that the “points” field has been removed from every document.

Example 2: Remove Multiple Fields

We can use the following code to remove the “points” and “position” field from every document in our collection:

db.teams.updateMany({}, {$unset: {"points":1, "position":1}})

We can then use the following query to view each document in our collection:

db.teams.find()

This query returns the following results:

{ _id: ObjectId("61893bf896cd2ba58ce928f7"), team: 'Mavs' }
{ _id: ObjectId("61893bf896cd2ba58ce928f8"), team: 'Spurs' }
{ _id: ObjectId("61893bf896cd2ba58ce928f9"), team: 'Rockets' }

Notice that the “points” and “position” fields have been removed from every document.

Note: You can find the complete documentation for $unset .

Additional Resources

The following tutorials explain how to perform other common operations in MongoDB:

Cite this article

stats writer (2024). How can I remove a field from every document in MongoDB?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-remove-a-field-from-every-document-in-mongodb/

stats writer. "How can I remove a field from every document in MongoDB?." PSYCHOLOGICAL SCALES, 2 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-remove-a-field-from-every-document-in-mongodb/.

stats writer. "How can I remove a field from every document in MongoDB?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-remove-a-field-from-every-document-in-mongodb/.

stats writer (2024) 'How can I remove a field from every document in MongoDB?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-remove-a-field-from-every-document-in-mongodb/.

[1] stats writer, "How can I remove a field from every document in MongoDB?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.

stats writer. How can I remove a field from every document in MongoDB?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)
Slide Up
x
PDF
Scroll to Top