How to update inside the array in mongoDB

Question

Here i want to write the update query like inside tags array suppose value is good i want to change very-good.i had written but is not working properly,suppose insdie tags two value is there means , two values itself getting updated

my documents

    /* 1 createdAt:12/18/2018, 5:59:33 PM*/
{
    "_id" : ObjectId("5c18e82da073cdc5c70072dc"),
    "roleID" : "3",
    "tags" : [
        "good"
    ]
},

/* 2 createdAt:12/18/2018, 5:59:33 PM*/
{
    "_id" : ObjectId("5c18e82da073cdc5c70072db"),
    "roleID" : "2",
    "tags" : [
        "very-good",
        "good"
    ]
},

@Prasanna I have added a simple solution for you, using updateMany instead of update with {"multi": true} — JoshuaCS
– JoshuaCS, Commented Dec 18, 2018 at 13:35

JoshuaCS · Accepted Answer · 2018-12-18 13:49:23Z

1

This code worked perfectly, it uses updateMany instead of just update. This code uses the $ operator:

Code

db.QuestionContents.updateMany({contentID: {$in: contentID}, tags: "options-short"}, {$set: {"tags.$": "options-2x2"}});

More info in the docs

Output

Here is the result of db.QuestionContents.find({}):

edited Dec 18, 2018 at 13:49

answered Dec 18, 2018 at 13:34

JoshuaCS

2,6341 gold badge15 silver badges16 bronze badges

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

1 Comment

JoshuaCS Over a year ago

@Prasanna if my answer worked for you, please, mark it as accepted (green checkmark). Thnx!

Sourbh Gupta · Accepted Answer · 2018-12-18 13:31:41Z

0

Use this query to update -

db.QuestionContents.update({contentID: {$in: contentID}, tags: "options-short" }, {$set:{"tags.$":"options-short2*2"}},{"multi": true});

answered Dec 18, 2018 at 13:31

Sourbh Gupta

8337 silver badges16 bronze badges

Comments

Manjeet Singh · Accepted Answer · 2018-12-18 13:32:44Z

0

use $addToSet with $each

db.QuestionContents.update({contentID: {$in: contentID} }, {$addToSet:{tags:{
  $each:["options-2x2"]}}},{"multi": true});

answered Dec 18, 2018 at 13:32

Manjeet Singh

2,4061 gold badge18 silver badges39 bronze badges

1 Comment

user9988771 Over a year ago

it is not updating, it is inserting the inside the array, it has to update

Collectives™ on Stack Overflow

How to update inside the array in mongoDB

3 Answers 3

Code

Output

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Code

Output

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related