Querying an array in MongoDB?

Question

Test data
   

db.multiArr.insert({"ID" : "fruit1","Keys" : [["carrot", "banana"]]})
db.multiArr.insert({"ID" : "fruit2","Keys" : ["apple", "orange"]})
db.multiArr.insert({"ID" : "fruit2","Keys" : ["apple"]})

How do I query for Keys in ["apple", "orange", "carrot"]?
Need

 ({"ID" : "fruit2","Keys" : ["apple", "orange"]})
 ({"ID" : "fruit2","Keys" : ["apple"]})

Thanks.

Answer 1

db.multiArr.find({ 
  Keys: "apple"
});

https://docs.mongodb.com/manu...

Answer 2

If this is what you meant

db.multiArr.find({Keys: {$in: ["apple", "orange", "carrot"]}})
{ "_id" : ObjectId("5a6fcb43943f5c239f98fbe6"), "ID" : "fruit2", "Keys" : [ "apple", "orange" ] }
{ "_id" : ObjectId("5a6fcb44943f5c239f98fbe7"), "ID" : "fruit2", "Keys" : [ "apple" ] }