1

I have accidentally inserted the email and name columns around the wrong way

{ 
  "_id" : ObjectId("52e72d00d1c3f81199000002"), 
  "email" : "John", 
  "name" : "john@gmail.com"
}

How can I fix this on a per ObjectId basis?

buydadip
  • 8,150
  • 18
  • 72
  • 141
Jase Whatson
  • 4,143
  • 4
  • 34
  • 44
  • what do you mean "per object"? Is it just one document you want to update, many (defined), or all? – Jinxcat Feb 13 '14 at 10:50

3 Answers3

8
db.collection.update( { condition }, { $rename: { "email": "name" } } )

Don't forget change name field to something like name_tmp before this operation. Then rename name_tmp into email

Documentation here

Mustafa Genç
  • 2,549
  • 17
  • 33
2

Have a look at this question how can i update field with another field's value.

It is tough to do in a single update query but you can use a javascript forEach loop:

db.item.find(conditions...).forEach( function (doc) {
  var email = doc.name;
  var name = doc.email

  doc.email = email; 
  doc.name = name      
  db.item.save(doc); 
});

You could maybe look at doing this in a one-liner like this;

doc.email = [doc.name, doc.name = doc.email][0];

But this is untested.

Community
  • 1
  • 1
Ewan
  • 13,854
  • 6
  • 47
  • 58
  • Thanks, I was able to do it with - db.User.find({name:/@/}).forEach(function (doc){ var email = doc.name; var name = doc.email; doc.email = email; doc.name = name; db.User.save(doc); }); – Jase Whatson Feb 13 '14 at 12:47
1

Thanks it works for me but I have had to set the option 'multi' to true.

db.collection('collection').update({ condition }, { $rename: { "currentName": "newName" } }, { multi: true });

francoiscabrol
  • 51
  • 2