MongoDB – Update to upper case

By mkyong | Updated: January 29, 2015

Viewed: 786 (+4 pv/w)

Tags: mongodb update uppercase

A document, and you want to update all the ‘source’ values to UPPERCASE.

{
	"_id" : NumberLong(1),
	"country" : "au",
	"source" : "apnic"
}
{
	"_id" : NumberLong(2),
	"country" : "cn",
	"source" : "apnic"
}
{
	"_id" : NumberLong(3),
	"country" : "us",
	"source" : "arin"
}

Solution

No sure if there is any ready function, but you can write a script to update the value to uppercase :

db.whois.find({ "source": { "$exists": true } }).forEach(function(doc) {
    db.whois.update(
        { "_id": doc._id },
        { "$set": { "source": doc.source.toUpperCase() } }
    );
});

Output

{
	"_id" : NumberLong(1),
	"country" : "au",
	"source" : "APNIC",
}
{
	"_id" : NumberLong(2),
	"country" : "cn",
	"source" : "APNIC",
}
{
	"_id" : NumberLong(3),
	"country" : "us",
	"source" : "ARIN",
}

Done.