MongoDB AND Operator

Mongodb $and operator performs AND operation on an array of two or more expressions.

Syntax of AND operator

"$and" : [expr1[, expr2, ..., exprN]]

It returns true if all expressions are true.

Example

Suppose, we have following collection.

{ "_id" : ObjectId("5b7ddc4f529cbc23546dc4c7"), "name" : "Jorz Rai", "age" : 10, "class" : "5A" }
{ "_id" : ObjectId("5b7ddf10529cbc23546dc4c8"), "name" : "Rana Soi", "age" : 11, "class" : "5C" }
{ "_id" : ObjectId("5b7de0f4529cbc23546dc4c9"), "name" : "Andy Joya", "age" : 11, "class" : "5C" }
{ "_id" : ObjectId("5b7de0f4529cbc23546dc4ca"), "name" : "Mary Soi", "age" : 11, "class" : "5C" }
{ "_id" : ObjectId("5b7de0f4529cbc23546dc4cb"), "name" : "Priska Somya", "age" : 12, "class" : "6A" }

The given statement select documents where the age equals to 11 and class equals to '5C'.

db.students.find({
	$and : [
		{"age" : 11},
		{"class" : '5C'}
	]
}).pretty();

mongodb AND operator





Read more articles