Write a MongoDB query to update specific fields in multiple documents in a collection.

Question

Aryan Kumar · Answer

Sure, here is a MongoDB query to update specific fields in multiple documents in a collection:

db.collection.updateMany({ name: 'John Doe' }, { $set: { age: 35, address: '123 Main Street' } });

This query updates the age and address fields in all documents in the collection where the name field is equal to John Doe. The $set operator is used to update the fields, and the values of the fields are specified in the object literal.

For example, if the collection contains the following documents:

{ name: 'John Doe', age: 30, address: '456 Elm Street' }
{ name: 'Jane Doe', age: 25, address: '789 Oak Street' }

Then, the query would update the age and address fields in the first document to 35 and 123 Main Street, respectively. The second document would not be updated, because the name field does not match the filter.

To run this query, you would need to connect to the MongoDB database and get the collection. Then, you could execute the query using the updateMany() method.

Here is an example of how you could run the query:

const client = new MongoClient('mongodb://localhost:27017/mydb');
const db = client.db('mydb');
const collection = db.collection('people');

collection.updateMany({ name: 'John Doe' }, { $set: { age: 35, address: '123 Main Street' } });

This code would connect to the MongoDB database and get the people collection. Then, it would execute the query to update the age and address fields in the document where the name field is equal to John Doe.

forum

Write a MongoDB query to update specific fields in multiple documents in a collection.

Can you answer this question?

1 Answers