using set in mongodb using regular expression [duplicate]

Question

I want to annotate some messages in MongoDB from a social network as spam. If I use in the query _id, it works, but not using regular expression.

this works for one record:

db.group_data.update({_id:"gid_91496835_topic_192"},{$set:{SPAM:true}})

this doesn't work for all, but seems to update one record:

db.group_data.update({"text":/.*yburlan.ru.*/},{$set:{SPAM:true}})

WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

How can I update/set to all records found by regexp?

Till · Accepted Answer · 2016-04-05 09:41:42Z

3

You should add the multi option :

db.group_data.update({"text":/.*yburlan.ru.*/}, {$set:{SPAM:true}}, {multi: true})

answered Apr 5, 2016 at 9:32

Till

4,6013 gold badges19 silver badges20 bronze badges

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

1 Comment

YES! cool, many many thanks!