MongoDB - How to find for both string and string array

Question

I'm a beginner at MongoDB.

I want to find documents in MongoDB by favorite.foods.

Here are documents

{
  "_id":1,
  "favorite": {
    "color":"red",
    "foods":{
      "fruits":"banana",
      "fastfood":["burger", "sandwich"]
    }
  }
},
{
  "_id":2,
  "favorite": {
    "color":"green",
    "foods":{
      "noodles":"ramen",
      "fastfood":["fries", "burger", "corn dog"]
    }
  }
},
{
  "_id":3,
  "favorite": {
    "color":"red",
    "foods":{
      "soup":"cream soup"
    }
  }
}

I tried to

db.collectionName.find({"favorite.foods":{"fruits":"banana","fastfood":{"$all":["burger", "sandwich"]}}})

but couldn't find id 1...

Please help me.

Yong Shun · Accepted Answer · 2021-11-08 04:08:42Z

1

With dot notation.

db.collection.find({
  "favorite.foods.fruits": "banana",
  "favorite.foods.fastfood": {
    "$all": [
      "burger",
      "sandwich"
    ]
  }
})

Sample Mongo Playground

answered Nov 8, 2021 at 4:08

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

11 Comments

bob Over a year ago

do I have to use dot?

ray Over a year ago

@bob This answer works because it tries to match on 2 different fields inside the favorite.foods object. Your initial attempt is close, but you are trying to match the whole favorite.food object so you cannot fetch the expected document. Thanks YongShun for this clean and concise answer.

Yong Shun Over a year ago

And thanks to @ray for the explanation in detail. =)

Yong Shun Over a year ago

Hi @bob, you may have a look at the link I shared for the sample query for the embedded documents.

bob Over a year ago

oh, sorry! I was wrong spell. thank :)

|

Collectives™ on Stack Overflow

MongoDB - How to find for both string and string array

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related