Shailendra Chauhan
03
Jun
In RDBMS, you can use comparison operators like as
![]()
>, <, <=, and >= while writing a SQL query. Mongo shell also has the 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.Take our free skill tests to evaluate your skill!
In less than 5 minutes, with our skill test, you can identify your knowledge gaps and strengths.
