Query all username fields in MongoDB

Question

I know this is a very basic question but I have done hours of research and I can't find it anywhere so maybe it's also useful for other people.

I just downloaded MongoDB Compass because I'm trying to export all username from my account collection and there's no way I can create a query that returns only the username field.

How can I, with MongoDB, get all the values of a specific field?

Thank you

Did you try projection as `db.collection('account').find({}, {username: true})`? — Farooq Ahmed Khan, Oct 21 '19 at 17:44
simply use 1 in front of the field name to project it, `db.collection('your_collection_name').find({}, { "your_field_name": 1 })`, thats all. — niranjan_harpale, Oct 21 '19 at 19:05

Developer · Accepted Answer · 2019-10-31T04:19:41.587

2

Use Projection.

Where you can add or remove Field in results of data.

Try

db.collection.find({}, { user_name : 1})

Where 1 is true and 0 is false.

edited Oct 31 '19 at 04:19

answered Oct 21 '19 at 18:10

Developer

3,309
2
19
23

score 0 · Answer 2 · answered Oct 22 '19 at 02:52

0

This will return only user_name field from all documents

db.collection.find({}, {"_id": 0, "user_name": 1})

answered Oct 22 '19 at 02:52

Dexter

831
8
17

Query all username fields in MongoDB

2 Answers2