Please enable Javascript to correctly display the contents on Dot Net Tricks!

Mongo DB Comparison Operators

  Author : Shailendra Chauhan
Posted On : 29 May 2015
Total Views : 5,730   
Updated On : 29 May 2015
 
In RDBMS, you can use comparison operators like as >, <, <=, and >= while writing a SQL query. Mongo shell also has same comparison operators but they are used with a different notation. Here is a comparison list of Mongo shell operators and SQL operators.

Mongo Shell Operators
SQL Operators
gt
>
lt
<
gte
>=
lte
<=

AND and OR Operators

Like RDBMS, MongoDB also supports OR and AND operators. You can use $or for an OR operator and $and for an AND operator.

db.users.find( { $or : [{lastname :"chauhan",lastname:"kumar"}] })
db.users.find( { $and : [{firstname :"deepak",lastname:"kumar"}] })
What do you think?
That’s it for now! I hope you get a good idea how to use Mongo shell comparison operators to query your mongo database. I would like to have feedback from my blog readers. Your valuable feedback, question, or comments about this article are always welcome.



Free Interview Books
 
COMMENTS (0)
3 APR
Master Class Fast Track MVC 5 with Angular2 Development (Online)

10:30 AM -03:30 PM IST (Fast Track)

Know More
25 MAR
MEAN Stack 2 Development (Classroom)

11:00 AM-12:30 PM

Know More
25 MAR
ASP.NET MVC with Angular2 Development (Classroom)

3:00 PM-4:30 PM

Know More
25 MAR
Xamarin Forms : Build Cross-platform Apps (Classroom)

8:00 AM-9:30AM

Know More
21 MAR
ASP.NET MVC with Angular2 Development (Online)

09:00 PM - 11:00 PM IST( TUS, THR, SAT)

6 MAR
ASP.NET MVC with Angular2 Development (Online)

07:00 AM - 09:00 AM IST( MON, WED, FRI)

25 FEB
ASP.NET MVC with Angular2 Development (Classroom)

05:00 PM-06:30 PM

31 JAN
ASP.NET MVC with Angular2 Development (Online)

07:00 AM-09:00 AM IST(Tuesday & Thursday)

30 JAN
NODEJS & MEAN Stack 2.x Development (Online)

09:00 PM-11:00 PM IST( MON, WED, FRI)

31 DEC
ASP.NET MVC with AngularJS Development (Classroom)

09:30 AM-11:00 AM

BROWSE BY CATEGORY
 
 
LIKE US ON FACEBOOK
 

Professional Speaks

+