update mongo db documents with regex

Question

I need to find all the documents in mongodb that have keywords that start with number 1-9, then add a '+' in front of the keyword, I can easily find the documents but cannot figure out how to update them.

I tried this one, but it doesn't work

db.placements.update({program_id:{$in:[113,107]},
                     keyword:{$regex:'^[0-9]', $options:'i'}}, 
                     {keyword:"+"+$keyword})

It cannot recognize $keyword, I also tried '.keyword', 'keyword', none of them works. Is there any way to reference the document itself like Java does, using 'this', so I can do something like

this.keyword: "+" + this.keyword

crackmigg · Accepted Answer · 2022-09-02 12:30:02Z

17

You'll have to use the $set operator in the update query to update a specific field. Also, you cannot concatenate string within an update query. One way to do this would be using cursor forEach() in the shell:

db.placements.find({program_id:{$in:[113,107]}, keyword:{$regex:'^[0-9]', $options:'i'}})
    .forEach(function(doc){ 
        db.placements.updateOne({_id:doc._id}, {$set:{"keyword":"+" + doc.keyword}})  
})

edited Sep 2, 2022 at 12:30

crackmigg

5,9412 gold badges35 silver badges41 bronze badges

answered Apr 3, 2014 at 16:38

Anand Jayabalan

13.1k6 gold badges44 silver badges54 bronze badges

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

Comments

Eitan · Accepted Answer · 2015-11-10 03:48:06Z

4

No, you cannot reference a value on the document itself when querying like you can with SQL.

I would suggest querying the document, updating it on your web/app server and then updating the value back to mongodb.

You will also find that your update command above will wipe your entire document leaving only the keyword field. You should use the $set modifier to update a field or set of fields.

db.placements.update(
    {
        program_id:{$in:[113,107]}, 
        keyword:{$regex:'^[0-9]', $options:'i'}
    }, 
    { $set: {keyword: new_value}})

edited Nov 10, 2015 at 3:48

Eitan

1631 gold badge4 silver badges12 bronze badges

answered Apr 3, 2014 at 16:28

Mark Unsworth

3,1872 gold badges22 silver badges21 bronze badges

1 Comment

Buzz Moschetti Over a year ago

Referencing a var in the doc itself is now possible (v4.2, 2019) with the pipeline form of $update.

Collectives™ on Stack Overflow

update mongo db documents with regex

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related