mongodbHow to use the "and" operator in MongoDB?
The and
operator in MongoDB is used to combine two or more expressions and retrieve documents that match all the expressions in the query.
For example, the following query will return documents that have the name
field set to John
and the age
field set to 25
:
db.collection.find({name: "John", age: 25})
The output of the above query will be documents that match both the name
and age
criteria:
{
"_id": ObjectId("5f3d7f3f3f3f3f3f3f3f3f3f"),
"name": "John",
"age": 25
}
The and
operator can also be used to combine multiple expressions in a single query. For example, the following query will return documents that have the name
field set to John
, the age
field set to 25
and the gender
field set to male
:
db.collection.find({name: "John", age: 25, gender: "male"})
The output of the above query will be documents that match all the criteria:
{
"_id": ObjectId("5f3d7f3f3f3f3f3f3f3f3f3f"),
"name": "John",
"age": 25,
"gender": "male"
}
The and
operator can also be used to combine multiple expressions in a single query using the $and
operator. For example, the following query will return documents that have the name
field set to John
and the age
field set to 25
or the gender
field set to male
:
db.collection.find({$and: [{name: "John"}, {$or: [{age: 25}, {gender: "male"}]}]})
The output of the above query will be documents that match either the name
and age
criteria or the name
and gender
criteria:
{
"_id": ObjectId("5f3d7f3f3f3f3f3f3f3f3f3f"),
"name": "John",
"age": 25
},
{
"_id": ObjectId("5f3d7f3f3f3f3f3f3f3f3f3f"),
"name": "John",
"gender": "male"
}
Helpful links
More of Mongodb
- How to use watch in MongoDB?
- What is MongoDB default port?
- How to perform a health check for MongoDB?
- How to list all indexes in MongoDB?
- How to use eq in MongoDB?
- How to update one document in MongoDB?
- How to order query results in MongoDB?
- How to check if array is empty in MongoDB?
- How to query with "not equal" condition in MongoDB?
- How to use transactions in MongoDB?
See more codes...