MongoDB select where in array of _id?

javascript arrays node.js mongodb express
itsme picture itsme · Oct 10, 2011 · Viewed 73.6k times · Source

is possible in mongo db to select collection's documents like in SQL :

SELECT * FROM collection WHERE _id IN (1,2,3,4);

or if i have a _id array i must select one by one and then recompose the array/object of results?

Answer

programmersbook picture programmersbook · Oct 10, 2011

Easy :)

db.collection.find( { _id : { $in : [1,2,3,4] } } );

taken from: http://www.mongodb.org/display/DOCS/Advanced+Queries#AdvancedQueries-%24in

Related questions

How to search in array of object in mongodb

Suppose the mongodb document(table) 'users' is { _id: 1, name: { first: 'John', last: 'Backus' }, birth: new Date('Dec 03, 1924'), death: new Date('Mar 17, 2007'), contribs: [ 'Fortran', 'ALGOL', 'Backus-Naur Form', 'FP' ], awards: [ { award: 'National Medal', year: 1975, by: 'NSF' }, { award: 'Turing Award', year: 1977, …

Read More
MongoDB, remove object from array

Doc: { _id: 5150a1199fac0e6910000002, name: 'some name, items: [{ id: 23, name: 'item name 23' },{ id: 24, name: 'item name 24' }] } Is there a way to pull a specific object from an array? I.E. how do I pull the entire item …

Read More
Convert Array to Object

What is the best way to convert: ['a','b','c'] to: { 0: 'a', 1: 'b', 2: 'c' }

Read More