Posted By : Shailendra Chauhan, 29 May 2015
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
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.