Python MongoDB - find_one Query

In PyMongo, the find_one() method is used to retrieve a single document from a MongoDB collection that matches the given filter. If multiple documents match, only the first match (based on insertion order) is returned.

Syntax

collection.find_one(filter, projection=None)

Parameters:

• filter: (dict) Criteria to search for a document (e.g., { "name": "Amit" }).
• projection (optional): (dict) Fields to include or exclude (e.g., { "_id": 0, "name": 1 }).

Here is our sample data.

Output

Explanation:

• MongoClient() connects to the local MongoDB server and selects the userDB.users collection.
• delete_many({}) clears any existing documents in the collection to avoid duplicate entries.
• insert_many(data) loads the sample user documents into the users collection.

Examples

Example 1: Find by name

Output

Explanation: Finds the first document where name is "Amit".

Example 2:find_one and exclude _id field

Output

Explanation: Finds the document where name is "Drew" and excludes the _id field from the result using projection.

Example 3: Find by "age" condition

Output

Explanation: Finds the first document where age is greater than 26 using the $gt (greater than) operator.

Related Articles

• Python MongoDB
• Python MongoDB - insert_one()
• MongoDB Projection with Examples
• Using Comparison Operators in MongoDB Queries