How to take the value of a key in mongodb using python

Question

I am new to mongoDB. I am using pymongo. Here I have an example list of favorite colors stored in a mongoDB collection named colors:

mylist = [
    {"name": "Amy", "color": "Red"},
    {"name": "Hannah", "color": "Blue"},
    {"name": "Michael", "color": "Green"},
    {"name": "Sarah", "color": "Orange"}
]

Using the search query how do I take the value "color" using query searching using a name like Michael? So the output would be like:

Green

Ravi Shankar Bharti · Accepted Answer · 2020-10-11 18:25:36Z

1

You can do it something like this:

Assuming that name is unique, you can try this:

db.colors.find_one({"name" : "Michael"})["color"]

You can read more about find_one here

answered Oct 11, 2020 at 18:25

Ravi Shankar Bharti

9,2786 gold badges31 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

How to take the value of a key in mongodb using python

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