Articles → MONGODB → $And Logical Operator In Mongodb

$And Logical Operator In Mongodb

In this article, we will discuss the $and logical operators in MongoDB.

Purpose

The $and logical operator is used to perform the logical AND operation.

Syntax

db.collection.find({
    $and: [
        { condition1 },
        { condition2 },
        { condition3 },
        // More conditions if needed
    ]
})

Example

Consider the following collection: -

Picture showing the sample sales collection

To perform the logical $and operation, we will write this query: -

db.sales.find({$and: [{ "product":"A"},{ "quantity":5}]})

Output

Posted By -	Karan Gupta

Posted On -	Saturday, February 24, 2024

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**