25
AprMongo DB Comparison Operators
22 Dec 2023
Intermediate
11.6K Views
1 min read
Learn via Video Course & by Doing Hands-on Labs
Node.js Course
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"}] })