mongo .find return specific field only for all user [duplicate]

Question

db.users.find({}) returns all the users with all the field.

How to write a request that would return only the 'email' field for all user ?

Use the find projection parameter - db.users.find({}, {email:1, _id:0}) — joao
– joao, Commented Nov 29, 2015 at 11:04

Philipp · Accepted Answer · 2018-12-21 11:30:32Z

38

Please take a look at the documentation. You will notice that find has an optional second parameter called "projection". This parameter is used to state which fields you want. To get only the field named "email", use this projection:

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

edited Dec 21, 2018 at 11:30

answered Nov 29, 2015 at 11:05

Philipp

70.1k10 gold badges121 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

François Richard Over a year ago

yep, I've read (too quickly) this part of the doc, trying things like that db.users.find({}, {email:*}) , should have read more seriously =) thanks

van le Over a year ago

when add _id: 0 or _id: false, it also return _id: null How can we eliminate _id ni from the result get back?

Collectives™ on Stack Overflow

mongo .find return specific field only for all user [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related