Mongo DB Comparison Operators

Mongo DB Comparison Operators

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

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"}] })