Mongo DB Comparison Operators

Shailendra Chauhan  Print 
Posted On : 29 May 2015
Updated On : 29 May 2015
Total Views : 7,546
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.



ABOUT AUTHOR

Shailendra Chauhan
An Entrepreneur, Microsoft MVP, Author, Architect And Corporate Trainer

He is a founder and CEO of Dot Net Tricks. He is the author of some of most popular e-books which encompass technical Interview on Node.js Interview Questions and Answers, ASP.NET MVC Interview Questions and Answers, AngularJS Interview Questions and Answers and LINQ Interview Questions and AnswersKnow more...

Free Interview Books
 
COMMENTS
SUBSCRIBE OUR YOUTUBE CHANNEL
 
 
 
LIKE US ON FACEBOOK
 
+