The $exists operator checks whether a field is present in a document. Use it in $match or find() to filter records that have (or lack) a specific field — essential for schema checks and data quality workflows.
Check if a field exists.
{ field: { $exists: bool } }
Filter in aggregation pipelines.
Present vs missing fields.
Data quality, optional fields.
Exists ≠ non-null value.
In MongoDB, the $exists operator tests whether a document contains a given field. Use { email: { $exists: true } } to find documents where email is present, or { phone: { $exists: false } } to find documents where phone is completely absent. This is especially useful when documents in the same collection have different shapes (optional or legacy fields).
$exists: true matches documents where the field is present even if its value is null. To find documents with a real value, combine $exists: true with { field: { $ne: null } }.
The $exists operator takes a boolean value that controls whether the field must be present or absent:
{ field: { $exists: <boolean> } }$exists: true — matches documents where the field is present (value can be anything, including null).$exists: false — matches documents where the field is missing entirely.find() queries and the $match stage of aggregation pipelines."address.city").$and, $or, and other query operators for complex filters.These are different in MongoDB. Know which one you need:
{ email: null } → field exists with null value ($exists: true){ name: "Alice" } (no email key) → field is missing ($exists: false){ email: { $exists: true, $ne: null } }| Question | Answer |
|---|---|
| Operator type | Query operator |
| Syntax | { field: { $exists: <boolean> } } |
true | Field is present (may be null) |
false | Field is missing entirely |
| Common stages | $match, find() |
{
email: { $exists: true }
}Has email field
{
phone: { $exists: false }
}No phone field
{
email: {
$exists: true,
$ne: null
}
}Has real email
{
"address.city": {
$exists: true
}
}Dot notation
Walk through sample user documents with optional fields, filter by field presence with $match, and learn the difference between missing fields and null values.
Use a users collection where some documents have optional fields and others do not.
Suppose you have a users collection with mixed field shapes:
[
{ "_id": ObjectId("609c26812e9274a86871bc6a"), "name": "Alice", "email": "alice@example.com" },
{ "_id": ObjectId("609c26812e9274a86871bc6b"), "name": "Bob", "email": null },
{ "_id": ObjectId("609c26812e9274a86871bc6c"), "name": "Charlie" }
]Return users who have an email field (including those where email is null):
db.users.aggregate([
{
$match: {
email: { $exists: true }
}
}
])email key, so they match.email field at all, so he is excluded.null value still counts as the field existing.Find missing optional fields, require non-null values, and audit data quality in pipelines.
Locate users who have no phone field at all:
db.users.aggregate([
{
$match: {
phone: { $exists: false }
}
}
])$exists: false only matches documents where the field is completely absent. A document with phone: null would not match this filter.
Find users with a real email address (field exists and is not null):
db.users.aggregate([
{
$match: {
email: { $exists: true, $ne: null }
}
}
])Combining $exists: true with $ne: null is the standard pattern when you need an actual value, not just the presence of the key.
Find profiles that include a city in their address:
db.users.aggregate([
{
$match: {
"address.city": { $exists: true }
}
}
])Dot notation works with $exists for nested documents. This matches any document where address.city is present, regardless of its value.
$exists WorksFor each document, MongoDB checks whether the specified field key is stored — at the top level or via dot notation for nested paths.
With $exists: true, documents where the field is present pass. With $exists: false, only documents without the field pass.
In $match, only matching documents move to the next stage. Non-matching documents are filtered out.
You get only documents that have (or lack) the field you care about — ready for cleanup, enrichment, or reporting.
The $exists operator is an essential query tool for working with MongoDB’s flexible schema. It lets you find documents that contain (or lack) specific fields — critical for data quality checks, optional field handling, and migration validation.
For beginners, remember: $exists: true means the field is present (even if null), $exists: false means the field is missing entirely, and combining with $ne: null gives you documents with real values.
$exists: true to find documents with a field present$exists: false to find documents where a field is missing$ne: null when you need a non-null value"address.city"$exists early in pipelines with $match for performance$exists: true excludes null values (it does not)$exists inside $project (it is a query operator, not an expression)$exists: false won’t match field: null$exists$existsUse these points when checking field presence in MongoDB.
Checks if a key exists.
Purpose{ field: { $exists: bool } }
Query and aggregation.
UsageFind missing fields.
Use caseExists true matches null.
Edge caseMove on to $exp for exponential math, or review $eq for equality comparisons.
5 people found this page helpful