Mongoose find and replace specific phrase the document

Question

I have documents like this:

    {
      _id: 'some id',
      body: 'i want some apple',
    },

    {
      _id: 'some id2',
      body: 'i want some apple and banana',
    }

And i want to find and replace all of document's body phrase some apple to lots of oranges.

Expected Results:

    {
      _id: 'some id',
      body: 'i want lots of oranges',
    },

    {
      _id: 'some id2',
      body: 'i want lots of oranges and banana',
    }

So i find all the documents with this:

    myDB.find({
        "body": {
          "$regex": "some apple",
          "$options": "i"
        }
      },
      function(err, docs) {
        console.log(docs);
      }
    );
)

But don't know how to replace and update only document's specific body phrase some apple to lots of oranges.

How do i do this?

If you are using `mongodb 4.2` version which allows `aggregation pipeline` in update. [This does it](https://stackoverflow.com/a/56556298/6082280) — ambianBeing, Sep 26 '19 at 16:36
Possible duplicate of [How to replace substring in mongodb document](https://stackoverflow.com/questions/12589792/how-to-replace-substring-in-mongodb-document) — ambianBeing, Sep 26 '19 at 16:37

score 4 · Accepted Answer · edited Sep 26 '19 at 17:14

4

You should consider mongoDB text index

You can implement by creating and index likee this:

db.yourCollectionName.createIndex({ body: "text" });

After which you can run this query:

db.yourCollectionName.updateMany(
      { $text: { $search: "\"some apple\"" }},
      { $set: { body: "i want lots of oranges" }},
      { new: true }
);

That should do it

edited Sep 26 '19 at 17:14

Ashok

2,846
1
12
20

answered Sep 26 '19 at 16:28

O'Dane Brissett

1,284
1
8
23

I created index body use ```myDB.index({body: 'text'}) ``` but how could i apply with mongoose that query? – bmer Sep 27 '19 at 07:22
The same query should work with your mongoose model @yong – O'Dane Brissett Sep 27 '19 at 15:06

score 2 · Answer 2 · answered Sep 26 '19 at 16:24

you can loop through and update

db.people.find({
    body: {
        $regex: "some apple",
        $options: "i"
    }
}).forEach(doc => {
    doc.body = doc.body.replace(/some apple/ig, 'lots of oranges');
    db.people.update({ _id: doc._id }, { $set: { body: doc.body } });
});

Mongoose find and replace specific phrase the document

2 Answers2