AND condition - using $and operator on document in collection in MongoDB

You are here : Home / MongoDB Tutorial



Contents of page >
  • AND condition - using $and operator on document in collection in MongoDB


AND condition - using $and operator on document in collection in MongoDB

First, Let's create new collection and insert document in it >
> db.employee.insert({_id : 1,  firstName:"ankit"})
> db.employee.insert({_id : 2,  firstName:"ankit", salary : 1000 })
> db.employee.insert({_id : 3,  firstName:"sam", salary : 2000 })
> db.employee.insert({_id : 4,  firstName:"neh", salary : 3000 })
First line above will create table (or collection) (if table already exists it will insert documents in it).


use AND condition - using $and operator in MongoDB.
Find employee where
_id = 1 and firstName = "ankit"
by using find method and $and operator.

> db.employee.find(
                               {$and : [
                                             {_id:1},
                                             {firstName:"ankit"}
                                            ]
                               }
                             )
Output>
{ "_id" : 1, "firstName" : "ankit" }






SUMMARY>
So in this mongoDB tutorial we learned how to use AND condition - using $and operator on document in collection in MongoDB.

Having any doubt? or you liked the tutorial! Please comment in below section.
Please express your love by liking JavaMadeSoEasy.com (JMSE) on facebook, following on google+ or Twitter.



RELATED LINKS>

What is MongoDB - A quick introduction to database


eEdit
Must read for you :