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

Mongo DB Comparison Operators

 Print 
  Author : Shailendra Chauhan
Posted On : 29 May 2015
Total Views : 6,373   
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
19 AUG
MEAN Stack 2 (Online)
5:30 Pm - 7:00 PM IST (+5:30 GMT)
19 AUG
ASP.NET MVC with Angular4 (Online)
10:30 Am to 12:30 PM IST (+ 5:30 GMT)
19 AUG
NodeJS with Angular4 (Classroom)
05:30 PM to 07:00 PM IST (+5:30 GMT)
12 AUG
Angular2 and Angular4 (Online)
08:00 AM - 10:00 AM IST(+5.30 GMT)
12 AUG
ASP.NET MVC with Angular4 (Classroom)
09:30 AM - 11:00 AM IST (+5:30GMT)
4 AUG
NodeJS with Angular4 (Online)
08:00 PM - 09:30 PM IST(+5.30 GMT)
26 JUL
ASP.NET MVC with Angular4 (Online)
07:00 AM - 09:00 AM IST(+5.30 GMT)
22 JUL
MEAN Stack 2 (Classroom)
04:00 PM - 05:30 PM IST(+5:30GMT)
20 JUL
Hadoop cum Administration (Online)
07:00 AM - 09:00 AM IST(+5:30 GMT)
15 JUL
ASP.NET MVC with Angular4 (Online)
03:30 PM - 05:30 PM IST(+5.30 GMT)
1 JUL
ASP.NET MVC with Angular4 (Classroom)
08:00 AM - 09:30 AM IST
1 JUL
MEAN Stack 2 (Classroom)
11:00 AM - 12:30 PM IST(+5:30 GMT)
30 JUN
Xamarin Forms : Build Cross-platform Apps (Online)
09:30 PM - 11:00PM IST(+5:30GMT)
6 JUN
ASP.NET MVC with Angular4 (Online)
09:00 PM-11:00 PM IST(+5.30 GMT)
LIKE US ON FACEBOOK
 
+