mongoDB – $or operator

$or Operator in mongoDB

or operator performs a logical or operation on an array of two or more  expressions and selects the documents that satisfy at least one of the expression.


Suppose we have an inventory collection. we want to select document where quantiry is less than 20 or price is 10.

We will use $or and after colon (:) we pass an array with columns we need to perform any operation.


> db.inventory.find( { $or: [ { quantity: { $lt: 20 } }, { price: 10 } ] } );

This query will find all document that have quantity less than 20 or price is 10.

If we have a students database with  marks collection and we want to select those students whose score is less that 50 or greater than 90 then we will use following query.



Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.