MongoDB. How to query array elements?

Question

PHP

Let's say we have an array:

'Pages': {
    {
      'title' => 'Page title 1',
      'tags' => ['Images', 'Movies']
    },

    {
      'title' => 'Page title 2',
      'tags' => ['Travels']
    },

    // ...
}

How to do a '$in' query on the 'tags' field for each element of an array? Is there an operator in mongodb used in a field name that stands for any numeric index? For example: pages.*.tags $in ['Movies', 'Travels'].

Answer 1

You can use aggregate, and then $unwind over the array.
At the end, if necessary, you can regroup.