Python MongoDB - Query

MongoDB queries let you filter documents(records) using conditions. The find() method retrieves documents from a collection, and you can pass an optional query to specify which documents to return.

A query is pass as a parameter to filter the results. This query uses key-value pairs and various operators.

Collection.find(query)

• query is optional. If no query is provided, it returns all documents in the collection.

Common MongoDB Query Operators

Following is the list of some operators used in the queries in MongoDB:

Sample Collection used in this article:

Example 1: 

This example filters and displays documents from the collection based on the Quantity field, the first query shows documents with Quantity greater than 40, while the second shows those with Quantity less than 40.

from pymongo import MongoClien

client = MongoClient("mongodb://localhost:27017/")
db = client["mydatabase"]
collection = db["GeeksForGeeks"]

cursor = collection.find({"Quantity": {"$gt": 40}})
print("The data having Quantity greater than 40 is:")
for doc in cursor:
    print(doc)

cursor = collection.find({"Quantity": {"$lt": 40}})
print("\nThe data having Quantity less than 40 is:")
for doc in cursor:
    print(doc)

Output

Example 2: 

It demonstrates the use of logical operators in MongoDB queries, the first query uses $and to retrieve documents where Quantity satisfies both conditions and the second uses $or to fetch documents where Quantity meets at least one condition.

from pymongo import MongoClient

client = MongoClient("mongodb://localhost:27017/")
db = client["mydatabase"]
collection = db["GeeksForGeeks"]

cursor = collection.find({"$and": [{"Quantity": {"$gt": 40}}, {"Quantity": {"$gt": 50}}] })
print("\nQuantities greater than 40 AND Quantities greater than 40:")
for doc in cursor:
    print(doc)

cursor = collection.find({"$or": [{"Quantity": {"$gt": 40}}, {"Quantity": {"$gt": 50}}] })
print("\nQuantities greater than 40 OR Quantities greater than 40:")
for doc in cursor:
    print(doc)

Output

Related Articles:

• find() method
• Comparison query operators
• Logical query operators