Array Query Selectors

Welcome back to our MongoDB course! By now, you've become adept at querying with basic operators, logical conditions, and element queries. Today, we delve into array query selectors—an extremely powerful feature to simplify your data querying process in MongoDB. In this lesson, we'll explore the $size, $all, and $elemMatch array query selectors using our Comic Book Store database.

Array Query Selectors in MongoDB comprise a set of operators designed to handle queries specific to array fields. These selectors include:

• $size: Finds documents where an array contains a specified number of elements.
• $all: Finds documents where an array contains all the specified elements.
• $elemMatch: Finds documents containing an array element that matches all specified criteria.

The $size query selector is used to find documents where an array field has a specific number of elements. For example, to find a comic book that is related to exactly three other comics in our database, we use the $size operator with the value of 3:

use comic_book_store_db

db.comic_books.findOne(
    { related_comics: { $size: 3 } },
    { title: 1, related_comics: 1, _id: 0 }
)

This query searches for the first document in the comic_books collection where the related_comics array contains exactly three elements. The projection part { title: 1, related_comics: 1, _id: 0 } ensures that only the title and related_comics fields are returned, excluding the _id field.

The $all query selector is used to find documents where an array field contains all the specified elements. For instance, if we want to find a comic book that falls under both 'Action' and 'Superhero' genres, we can use the $all operator:

use comic_book_store_db

db.comic_books.findOne(
    { genres: { $all: ["Action", "Superhero"] } },
    { title: 1, genres: 1, _id: 0 }
)

This query looks for the first document in the comic_books collection that contains both 'Action' and 'Superhero' in its genres array.