Using mongodb, how would someone update a certain string inside an array?

Question

So, while building a webpage, I'd like to add a feature where you can change your password, email etc.. And I have all that info stored inside my database kinda like this:

// This is what it looks like in mongodb compass
Credentials: Array
0:
"email"
1:
"password"

how could I update 0 or 1?

J.F. · Accepted Answer · 2021-03-21 00:22:27Z

1

You can use dot notation to set the postion you want in this way (assuming position 0 is always email and position 1 is always password):

db.collection.update({
  "user": "your_user_or_whatever_way_to_identify"
},
{
  "$set": {
    "credentials.0": "new email",
    "credentials.1": "new pass"
  }
})

Example here

edited Mar 21, 2021 at 0:22

answered Mar 21, 2021 at 0:10

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using mongodb, how would someone update a certain string inside an array?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related