Swap the values in a MongoDB array

Question

I have an array like "geo": [39.897867,-121.8909978] in my MongoDb collection.

What I need to do is to swap the values present inside the array.

Please help me on this. Thank you...

Answer 1

You can swap by using array index . First find it and swap it.

db.myCollection.find().forEach(function(doc){
        db.myCollection.update({_id: doc._id},
          {$set: {"geo.0": doc.geo[1], "geo.1": doc.geo[0]}})
    })