Searching and retrieving multiple documents at once

[Sachin Anand]

Hi All,

Is there a way I can retrieve multiple documents in a single query which have different ids.

I want to retrieve document with ids as "_id":"sachin", "_id":"Doug", "_id":"Michael" in a single query.

The sql query would be something like :

select * from table_name where _id in ("sachin", "Doug", "Michael")

Thanks.

--
With Regards

Sachin Anand

[Nat]

Use $in operator.

db.persons.find({_id:{$in: ["sachin", "Doug", "Michael"]}});

http://www.mongodb.org/display/DOCS/Advanced+Queries 

[Sachin Anand]

I am looking for the java api usage. Any pointers.

[Shekhar Vemuri]

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

--
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To post to this group, send email to mongod...@googlegroups.com.
To unsubscribe from this group, send email to mongodb-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/mongodb-user?hl=en.

[Sachin Anand]

Thanks Nat, 

I am looking for its java api usage. Guess I was late with my update.

--

You received this message because you are subscribed to the Google Groups "mongodb-user" group.

To view this discussion on the web visit https://groups.google.com/d/msg/mongodb-user/-/McoIzc0aEjoJ.

To post to this group, send email to mongod...@googlegroups.com.
To unsubscribe from this group, send email to mongodb-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/mongodb-user?hl=en.

[Sachin Anand]

Thanks Nat and Shekhar. I guess this would work : new BasicDBObject(['_id':['$in':['e','b']]])