Delete a key in all the documents

Question

I have modified a schema (ie, users) by deleting a key (ie, ips). Thus I want to delete this key in all the documents in the database.

For example, in mongo console or Robo 3T, db.getCollection('users').find({}) returns all the users. Some of them contain the key ips. Does anyone know how to remove ips in the console or Robo 3T?

Try `db.getCollection('users').update( { }, { $unset: { ips: "" } } )` — s7vr, Dec 13 '17 at 20:29
Are you sure about that? I just tested, it did not work... Previously `ips` was defined as `[{ type: String }]` @Veeram — SoftTimur, Dec 13 '17 at 20:31
try this one `db.getCollection('users').update({},{ips : undefind})` — shahabvshahabi, Dec 13 '17 at 20:32
`ips` is `[{ type: String }]`, `users` is an Object that has several keys including `ips`. — SoftTimur, Dec 13 '17 at 20:34
Possible duplicate of [How to remove a field completely from a MongoDB document?](https://stackoverflow.com/questions/6851933/how-to-remove-a-field-completely-from-a-mongodb-document) — s7vr, Dec 13 '17 at 20:49

score 2 · Answer 1 · edited Jun 20 '20 at 09:12

2

Update Multiple Documents

To update multiple documents, set the multi option to true. Refer here

db.getCollection('users').update(
  { },
  { $unset: { ips: 1 } },
  { multi: true } 
)

edited Jun 20 '20 at 09:12

Community

1
1

answered Dec 13 '17 at 20:48

codejockie

9,020
4
40
46

score 1 · Accepted Answer · answered Dec 13 '17 at 20:39

As @Veeram already posted you can run a regular update with $unset just add multi: true in the options to update all documents, otherwise it will update just one

db.users.update(
  { }, // where
  { $unset: { ips: 1 } }, // change what
  { multi: true } // options
)

Delete a key in all the documents

2 Answers2