MongoDB $in Operator

What You’ll Learn

The $in operator matches documents when a field equals any value in a list. Use it in $match to filter by multiple categories, statuses, or IDs in one clean query instead of writing many $or conditions.

Definition and Usage

In MongoDB, the $in operator selects documents where a field’s value appears in a specified array. For example, { status: { $in: [ "active", "pending" ] } } returns every document whose status is either "active" or "pending". It is one of the most common query operators for multi-value filtering.

In aggregation expressions, { $in: [ "$role", [ "admin", "editor" ] ] } returns true or false depending on whether the field value is in the array. This is useful for adding flags or driving $cond logic.

📝 Syntax

$in has two forms depending on where you use it:

Query form (in $match or find filters)

{ field: { $in: [ <value1>, <value2>, ... ] } }

Aggregation expression form (in $project, $cond, etc.)

{ $in: [ <expression>, <array expression> ] }

Syntax Rules

• Query form — keeps documents where the field equals at least one value in the array.
• Expression form — returns true when the first operand is found in the second array.
• If the field is an array, a match occurs when any element in the field array equals a listed value.
• Values must match BSON types exactly (no automatic type conversion).
• An empty $in array { field: { $in: [] } } matches no documents.
• Use $nin for the opposite — exclude documents matching any listed value.

Examples Gallery

Walk through sample product data, filter by multiple categories with $match, and test membership with the expression form.

[
  { "_id": ObjectId("609c26812e9274a86871bc6a"), "name": "MongoDB Guide", "category": "books", "status": "active" },
  { "_id": ObjectId("609c26812e9274a86871bc6b"), "name": "Chess Set", "category": "games", "status": "active" },
  { "_id": ObjectId("609c26812e9274a86871bc6c"), "name": "Coffee Mug", "category": "kitchen", "status": "archived" }
]

db.products.aggregate([
  {
    $match: {
      category: { $in: ["books", "games"] },
      status: "active"
    }
  }
])

{ "_id": ObjectId("609c26812e9274a86871bc6a"), "name": "MongoDB Guide", "category": "books", "status": "active" }
{ "_id": ObjectId("609c26812e9274a86871bc6b"), "name": "Chess Set", "category": "games", "status": "active" }

db.articles.find({
  tags: { $in: ["mongodb", "database"] }
})

// tags: ["nodejs", "mongodb"]  → matches (contains "mongodb")
// tags: ["css", "html"]          → no match
// tags: "mongodb"                → matches (scalar value works too)

db.users.aggregate([
  {
    $project: {
      name: 1,
      role: 1,
      isPrivileged: {
        $in: [ "$role", ["admin", "editor", "moderator"] ]
      }
    }
  }
])

// role: "admin"   → isPrivileged: true
// role: "viewer"  → isPrivileged: false
// role: "editor"  → isPrivileged: true

db.orders.aggregate([
  {
    $project: {
      orderId: 1,
      country: 1,
      shippingTier: {
        $cond: [
          { $in: [ "$country", ["US", "CA", "MX"] ] },
          "domestic",
          "international"
        ]
      }
    }
  }
])

const ids = [
  ObjectId("609c26812e9274a86871bc6a"),
  ObjectId("609c26812e9274a86871bc6c")
];

db.products.find({
  _id: { $in: ids }
})

🚀 Use Cases

• Multi-value filtering — select documents by category, status, role, or region in one condition.
• Batch ID lookups — fetch many documents by _id or foreign key using an array of ObjectIds.
• Tag and skill matching — find articles, jobs, or users when an array field contains any target value.
• Conditional labeling — use the expression form inside $cond for routing, pricing tiers, or access control flags.

💡 Best Practices