Mongodb - remove or replace all array elements

Question

How can i replace all elements from a mongodb array element. As in below example, my requirement is to remove both object from skills array and add new elements in it.

{
    "_id": "uniqueid",
    "skills": [
        { "skill": "dancer" },
        { "skill": "singer" }
    ]
}

I need to replace all element of skills array field. How this can be achieved using mongodb java driver, or other query types?

You can overwrite your array. Just use db.colname.find({"_id": "uniqueid"}, {$set:{"skills":new array}}) — s7vr
– s7vr, Commented Oct 25, 2018 at 12:49

Tarek Essam · Accepted Answer · 2018-10-25 12:58:54Z

2

You just need to use $set operator $set to set skills to a new value which will be an array of the new element you want to replace with.

 db.collectionName.update(
   { _id: 'uniqueid' },
   { $set:
      {            
        skills: [{'new elements'}]
      }
   }
)

if you want to remove all elements set the skills to an empty array {skills: []}

if you want to remove a certain elements based on a value use $pull operator $pull

answered Oct 25, 2018 at 12:58

Tarek Essam

4,0602 gold badges15 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Mongodb - remove or replace all array elements

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related