How to add key-value pair to object in MongoDB

mongodb mongodb-update
flimflam57 picture flimflam57 · Aug 11, 2016 · Viewed 22k times · Source

If I have a document with the following basic structure:

{
  ...
  Monday: { a:1, b:2 },
  Tuesday: { c:3, d:4 }
  ...
}

Am I able to 'push' an additional key:value pair to Monday's value? Result would be:

{
  Monday: { a:1, b:2, z:8 },
  Tuesday: { c:3, d:4 }
  ...
}

The $push operator seems to only work for arrays.

Answer

DAXaholic picture DAXaholic · Aug 11, 2016

Just do something like that 

db.foo.update({"_id" :ObjectId("...") },{$set : {"Monday.z":8}})

Related questions

How to replace substring in mongodb document

I have a lot of mongodb documents in a collection of the form: { .... "URL":"www.abc.com/helloWorldt/..." ..... } I want to replace helloWorldt with helloWorld to get: { .... "URL":"www.abc.com/helloWorld/..." ..... } How can I achieve this for all documents …

Read More
MongoDB concatenate strings from two fields into a third field

How do I concatenate values from two string fields and put it into a third one? I've tried this: db.collection.update( { "_id": { $exists: true } }, { $set: { column_2: { $add: ['$column_4', '$column_3'] } } }, false, true ) which doesn't seem to …

Read More
How to query MongoDB with "like"?

I want to query something with SQL's like query: SELECT * FROM users WHERE name LIKE '%m%' How to do I achieve the same in MongoDB? I can't find an operator for like in the documentation.

Read More