How to query on array field with an aray in mongodb?

Question

Example of a document in a dummy collection.

{
    "_id": "1",
    "subjects": ['English', 'Maths', 'Science', 'French',..]
}

Now I want to select all the documents which are having any of the subjects mentioned in an array. Eg: ['Maths', 'French'].

So the result of the query should give all the documents wherever any of the subjects that are mentioned.

Therefore for the above examples, all the document's which are having Maths or French subjects should be returned.

varman · Accepted Answer · 2020-07-27 16:09:07Z

1

You can use $in operator with find() or aggregate()

db.collection.find({
  "subjects": {
    $in: [
      "English"
    ]
  }
})

Or

db.collection.aggregate([
  {
    $match: {
      subjects: {
        $in: [
          "Maths",
          "English"
        ]
      }
    }
  }
])

answered Jul 27, 2020 at 16:09

varman

8,9306 gold badges25 silver badges56 bronze badges

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

1 Answer 1