8

I want to remove key "passwrod" from all documents from users collection using mongoose , is it possible to do it using $unset ?

 { "_id" : ObjectId("58ec890c91b2b612084fd827"),
        "username" : "zain",
        "passwrod" : 123,
        "password" : 8 },
{   "_id" : ObjectId("58ec8918364116187845948d"),
        "username" : "bob",
        "password" : 123,
        "passwrod" : 12  }
Haris KK
  • 267
  • 1
  • 4
  • 14

1 Answers1

10

Documents: 

{ "_id" : ObjectId("58ec890c91b2b612084fd827"), "username" : "zain", "passwrod" : 123, "password" : 8 }
{ "_id" : ObjectId("58ec8918364116187845948d"), "username" : "bob", "password" : 123, "passwrod" : 12 }

Query:

db.collection.updateMany({}, {$unset:{"passwrod":1}})

Result:

{ "_id" : ObjectId("58ec890c91b2b612084fd827"), "username" : "zain", "password" : 8 }
{ "_id" : ObjectId("58ec8918364116187845948d"), "username" : "bob", "password" : 123 }
AshokGK
  • 875
  • 1
  • 10
  • 20
  • 4
    {$unset:{"passwrod":1}} , what does this 1 stands for? – Haris KK Apr 18 '17 at 10:38
  • 1
    it is not mandatory, you can use "" also, and it doesn't impact the operation check https://docs.mongodb.com/manual/reference/operator/update/unset/ for more details – AshokGK Apr 18 '17 at 10:48
  • db.collection.updateMany({}, {$unset:{"passwrod":1}}) db.collection.updateMany({}, {$unset:{"passwrod":2}}) db.collection.updateMany({}, {$unset:{"passwrod":""}}) db.collection.updateMany({}, {$unset:{"passwrod":null}}) db.collection.updateMany({}, {$unset:{"passwrod":"abcd"}}) all are valid – AshokGK Apr 18 '17 at 10:51