MongoDB Database, equivalent for SELECT column1, column2 FROM tbl

select mongodb rows
Marc Stevens picture Marc Stevens · Aug 26, 2011 · Viewed 24.2k times · Source

From my MongoDB I want the equivalent for

  SELECT column1, column2
  FROM tbl

With this code I get all the 'rows' but also all the 'columns'

  DBCollection collection = database.getCollection("names");
  DBCursor cursor = collection.find();

I for example would like all the 'rows' but only the 'columns': id, name, age

How would I do this?

Thanks for any help!!

Answer

cjohn picture cjohn · Aug 26, 2011

db.collection.find({}, {_id: 1, name: 1, age: 1})

The first argument to find (the predicate) is your selection criteria, e.g.

db.collection.find({age: {$gte: 21}})

The second limits the fields you retrieve, so for the names over everyone 21 or older:

db.collection.find({age: {$gte: 21}}, {name: 1})

The field selector always pulls back _id unless you specifically turn it off:

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

However, Mongo will not check for field existence by default. If you want to select certain fields, and match only results that have those fields, you will want to use:

db.collection.find({ age: { $exists: true } })

The MongoDB website has a more detailed description of the .find() function!

Related questions

How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
Selecting multiple columns in a pandas dataframe

I have data in different columns but I don't know how to extract it to save it in another variable. index a b c 1 2 3 4 2 3 4 5 How do I select 'a', 'b' and save it in to df1? I tried df1 = df[…

Read More
SQL SELECT WHERE field contains words

I need a select which would return results like this: SELECT * FROM MyTable WHERE Column1 CONTAINS 'word1 word2 word3' And I need all results, i.e. this includes strings with 'word2 word3 word1' or 'word1 word3 word2' …

Read More