LESS THAN (<) and LESS THAN EQUALS (<=) - using $where, $lt and $lte operator in MongoDB

You are here : Home / MongoDB Tutorial


Contents of page >

LESS THAN (<) and LESS THAN EQUALS (<=) - using  $where, $lt and $lte operator 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).

LESS THAN (<) and LESS THAN EQUALS (<=) conditions
1) LESS THAN (<) - using $lt operator.
Find employee where
Salary < 2000
by using find method and $lt operator.


> db.employee.find( { salary : {$lt : 2000} } )
Output>
{ "_id" : 2, "firstName" : "ankit", "salary" : 1000 }


2) LESS THAN EQUALS (<=) - using $lte operator in MongoDB.
Find employee where
Salary >= 2000
by using find method and $lt operator.


> db.employee.find( { salary : {$lte : 2000} } )
Output>
{ "_id" : 2, "firstName" : "ankit", "salary" : 1000 }
{ "_id" : 3, "firstName" : "sam", "salary" : 2000 }


3) LESS THAN (<) - using $where operator.
Find employee where
Salary < 2000
by using find method and $where operator.


> db.employee.find({  $where:"this.salary < 2000"})
Output>
{ "_id" : 2, "firstName" : "ankit", "salary" : 1000 }


4) LESS THAN EQUALS (<=) - using $where operator in MongoDB.
Find employee where
Salary >= 2000
by using find method and $where operator.


> db.employee.find({  $where:"this.salary <= 2000"})
Output>
{ "_id" : 2, "firstName" : "ankit", "salary" : 1000 }
{ "_id" : 3, "firstName" : "sam", "salary" : 2000 }




5) SUMMARY>
So in this mongoDB tutorial we learned how to use LESS THAN (<) and LESS THAN EQUALS (<=) - using  $where, $lt and $lte operator in MongoDB


LESS THAN (<) - using $lt operator.
Find employee where
Salary < 2000
> db.employee.find( { salary : {$lt : 2000} } )


LESS THAN EQUALS (<=) - using $lte operator.
Find employee where
Salary >= 2000
> db.employee.find( { salary : {$lte : 2000} } )


LESS THAN (<) - using $where operator.
Find employee where
Salary < 2000
> db.employee.find({  $where:"this.salary < 2000"})


LESS THAN EQUALS (<=) - using $where operator.
Find employee where
Salary >= 2000
> db.employee.find({  $where:"this.salary <= 2000"})


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 :