Update MongoDB collection using $toLower

by

MongoDB does not have a concept of $toLower as a command. The solution is to run a big for loop over the data and issue the updates individually.

You can do this in any driver or from the shell:

db.myCollection.find().forEach(
  function(e) {
    e.UserName = e.UserName.toLowerCase();
    db.myCollection.save(e);
  }
)

You can also replace the save with an atomic update:

db.myCollection.update({_id: e._id}, {$set: {UserName: e.UserName.toLowerCase() } })

Again, you could also do this from any of the drivers, the code will be very similar.

EDIT: Remon brings up a good point. The $toLower command does exist as part of the aggregation framework, but this has nothing to do with updating. The documentation for updating is here.

More Related Contents:

  1. MongoDB first time user setup [closed]
  2. How to execute mongo commands through shell scripts?
  3. pushing object into array schema in Mongoose
  4. Performing regex queries with PyMongo
  5. Check if every element in array matches condition
  6. What is the default database path for MongoDB?
  7. Updating nested arrays in mongoDB via mongo shell [duplicate]
  8. How can I get a random record from MongoDB?
  9. How do I convert a property in MongoDB from text to date type?
  10. Merging two collections in MongoDB
  11. MongoDB can’t find data directory after upgrading to Mac OS 10.15 (Catalina)
  12. Matching ObjectId to String for $graphLookup
  13. MongoDB-CR Authentication failed
  14. Mongodb aggregation lookup with conditions
  15. Create an ISODate with pyMongo
  16. E: Unable to locate package mongodb-org
  17. Poor lookup aggregation performance
  18. Using “$count” Within an “addField” Operation in MongoDB Aggregation
  19. unable to start mongodb local server
  20. How to connect Robomongo to MongoDB
  21. MongoDB cannot start server: The default storage engine ‘wiredTiger’ is not available with this build of mongod
  22. getting schema attributes from Mongoose Model
  23. How to limit number of updating documents in mongodb
  24. Mongodb Aggregation Framework | Group over multiple values?
  25. How does MongoDB order their docs in one collection? [duplicate]
  26. How to stop mongo DB in one command
  27. MongoDB on Ubuntu won’t start as a service, nothing in the log
  28. MongoDB: how to count number of keys in a document?
  29. Mongodb concat int and string
  30. Aggregation with update in mongoDB

Leave a Comment