Deeper Query Operators

Beyond simple equality

Earlier you used $gt, $lt and $in. Real documents need more: they hold arrays (a user’s skills, a product’s tags) and optional fields that some documents have and others do not. This lesson adds the operators that handle those cases — the ones paid courses spend extra time on because real queries need them.

Array operators

Say each user has a skills array like ["HTML", "CSS", "React"]. Three operators let you ask different questions about it:

// $in — has AT LEAST ONE of these skills
db.users.find({ skills: { $in: ["React", "Vue"] } })

// $all — has ALL of these skills
db.users.find({ skills: { $all: ["HTML", "CSS"] } })

// $elemMatch — an array of objects where ONE element matches several conditions
db.users.find({
  grades: { $elemMatch: { subject: "Math", score: { $gte: 90 } } }
})

Compare them carefully. $in matches a user if their skills array contains any one of the listed values — so React-only users and Vue-only users both match. $all is stricter: it matches only users whose array contains every listed value (here both HTML and CSS). $elemMatch is for arrays of objects: it finds documents where a single element of the array satisfies all the conditions at once — here, one grade entry that is both Math and scored 90 or above. (Without $elemMatch, MongoDB could match a Math entry and a separate high score from a different subject, which is usually not what you want.)

Existence and type

Because MongoDB’s schema is flexible, some documents may be missing a field entirely, or hold the wrong type. $exists checks whether a field is present at all; $type checks its data type.

// Users who HAVE a phone field
db.users.find({ phone: { $exists: true } })

// Documents where age is actually stored as a number
db.users.find({ age: { $type: "number" } })

{ phone: { $exists: true } } returns only the documents that include a phone field at all (useful for finding incomplete records). { age: { $type: "number" } } returns documents where age is genuinely a number — handy for catching data that was accidentally saved as text like "22" instead of 22.

Pattern matching with $regex

A regular expression (regex) is a small pattern for matching text — like a wildcard search. $regex lets you find documents whose field text matches a pattern, which powers simple search boxes.

// Names that start with "As" (case-insensitive)
db.users.find({ name: { $regex: "^As", $options: "i" } })

The pattern "^As" means “text that starts with As” — the ^ symbol anchors the match to the beginning. The $options: "i" makes it case-insensitive, so “Asha”, “astrid” and “ASHOK” all match. This is the quick way to build a “search as you type” name filter.