mongodb update many

MongoDB Update Many

If you want to update multiple documents in MongoDB, you can use the updateMany() method. This method will update all documents matching the specified filter.

Syntax

db.collection.updateMany(filter, update, options)

• filter: Specifies the selection criteria for the update. This parameter uses the same syntax as the find() method.
• update: Specifies the modifications to apply.
• options: Optional. Specifies additional options, such as sort order and limit.

Example

Suppose you have a collection called "users" with the following documents:

{
  "_id": ObjectId("5f63a8c1d28f1e3e3c3e8ea8"),
  "name": "John",
  "age": 30
}
{
  "_id": ObjectId("5f63a8c1d28f1e3e3c3e8ea9"),
  "name": "Jane",
  "age": 25
}
{
  "_id": ObjectId("5f63a8c1d28f1e3e3c3e8eaa"),
  "name": "Bob",
  "age": 40
}

If you want to update the age of all users with the name "John", you can use the following command:

db.users.updateMany(
  { name: "John" },
  { $set: { age: 35 } }
)

This will update all documents with the name "John" and set their age to 35.

You can also use the $inc operator to increment a field by a certain value. For example, if you want to add 5 to the age of all users with the name "Jane", you can use the following command:

db.users.updateMany(
  { name: "Jane" },
  { $inc: { age: 5 } }
)

This will update all documents with the name "Jane" and add 5 to their age.

Remember to always use caution when updating multiple documents at once, as it can have unintended consequences.