How to Select Specific Fields in MongoDB: Syntax and Examples

In MongoDB, you select specific fields by using a projection in your find() query. The projection is an object where you set the fields you want to include to 1 and exclude others by default.

Syntax

The basic syntax to select specific fields in MongoDB uses the find() method with two arguments: the query filter and the projection object.

• Query filter: Defines which documents to find.
• Projection: Specifies which fields to include or exclude.

Example: db.collection.find(filter, projection)

mongodb

db.collection.find(filter, { field1: 1, field2: 1 })

Example

This example shows how to find all documents in the users collection but only return the name and email fields.

mongodb

db.users.find({}, { name: 1, email: 1, _id: 0 })

Output

[
  { "name": "Alice", "email": "[e-mail]" },
  { "name": "Bob", "email": "[e-mail]" }
]

Common Pitfalls

Common mistakes when selecting fields include:

• Mixing inclusion and exclusion in projection (except for _id).
• Forgetting that _id is included by default unless explicitly excluded.
• Using 0 to exclude fields but accidentally excluding all fields.

Always choose either to include fields (1) or exclude fields (0) except for _id.

mongodb

/* Wrong: mixing inclusion and exclusion */
db.users.find({}, { name: 1, email: 0 })

/* Right: only inclusion */
db.users.find({}, { name: 1, email: 1 })

Quick Reference

Action	Projection Syntax	Description
Include fields	{ field1: 1, field2: 1 }	Returns only these fields in results
Exclude fields	{ field1: 0, field2: 0 }	Returns all fields except these
Exclude _id	{ _id: 0 }	Removes the _id field from results
Default	No projection	Returns all fields including _id

Key Takeaways

Use projection in find() to select specific fields by setting them to 1.

Do not mix inclusion and exclusion in the same projection except for _id.

_id is included by default; exclude it explicitly if not needed.

Projection helps reduce data transfer by returning only needed fields.

Use empty filter {} to select all documents when testing projections.