How can I replace a substring with another in mongodb?

Question

I want to replace a substring "are" with "any test" in all "ques" document of "user" collection,but my query is replace the full document string with "any test".I am new to mongo. Please someone suggest me what wrong with my query?

Here is my mongo query.

db.user.find({ques:{$regex:'are'}}).forEach(function (e, i) {e.ques =  e.ques.replace(/are/, 'any test'), printjson(e); db.ques.save(e);} )

Does this answer your question? How to replace substring in mongodb document — PZBird
– PZBird, Commented Jan 18, 2023 at 6:43
PZBird.this command db.faq.find().forEach(function(o) {o.ques = o.ques.replace(/hello/, "How"); printjson(o);db.faq.save(o)}) is okay in localhost but in server it show that "db.faq.save" is not a function — user17143140
– user17143140, Commented Jan 18, 2023 at 7:29

lpizzinidev · Accepted Answer · 2023-01-18 07:52:28Z

0

Try with:

db.user.find({ ques: { $regex: 'are' } }).toArray((err, users) => {
    if (err) return;
    for (const u of users) {
        u.ques = u.ques.replace(/are/, 'any test');
        db.user.save(u);
    }
});

edited Jan 18, 2023 at 7:52

answered Jan 18, 2023 at 7:26

lpizzinidev

13.3k2 gold badges15 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user17143140 Over a year ago

Hii @lpizzinidev I found "MongoServerError: Expected field projectionto be of type object" error

lpizzinidev Over a year ago

@RatnambarGupta Try with toArray (see edited answer)

Collectives™ on Stack Overflow

How can I replace a substring with another in mongodb?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related