OR condition - using $or operator on document in collection in MongoDB

You are here : Home / MongoDB Tutorial



Contents of page >
  • OR condition - using $or operator on document in collection in MongoDB


OR condition - using $or 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 OR condition - using $or operator in MongoDB.
Find employee where
id = 1 or firstName = "ankit"
by using find method and $or operator.

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






SUMMARY>
So in this mongoDB tutorial we learned how to use OR condition - using $or 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 :