Skip to content
Related Articles

Related Articles

Python MongoDB – Find

View Discussion
Improve Article
Save Article
  • Difficulty Level : Basic
  • Last Updated : 20 Jun, 2022
View Discussion
Improve Article
Save Article

MongoDB is a cross-platform document-oriented database program and the most popular NoSQL database program. The term NoSQL means non-relational. MongoDB stores the data in the form of key-value pairs. It is an Open Source, Document Database which provides high performance and scalability along with data modeling and data management of huge sets of data in an enterprise application. MongoDB also provides the feature of Auto-Scaling. It uses JSON-like documents, which makes the database very flexible and scalable.

Finding data from the collection or the database

In MongoDB, there are 2 functions that are used to find the data from the collection or the database.

  • find_one()
  • find()

Find_one() Method 

In MongoDB, to select data from the collection we use find_one() method. It returns the first occurred information in the selection and brings backs as an output. find_one() method accepts an optional parameter filter that specifies the query to be performed and returns the first occurrence of information from the database. 

Example 1: Find the first document from the student’s a collection/database. Let’s suppose the database looks like as follows:

python-mongodb-db1 

Python3




# Python program to demonstrate
# find_one()
 
 
import pymongo
 
 
mystudent = pymongo.MongoClient('localhost', 27017)
 
# Name of the database
mydb = mystudent["gfg"]
 
# Name of the collection
mycol = mydb["names"]
 
x = mycol.find_one()
 
print(x)


Output : python-mongodb-find-one1

Find()

find() method is used to select data from the database. It returns all the occurrences of the information stored in the collection. It has 2 types of parameters, The first parameter of the find() method is a query object. In the below example we will use an empty Query object, which will select all information from the collection. Note: It works the same as SELECT* without any parameter. 

Example: 

Python3




import pymongo
 
 
# establishing connection
# to the database
my_client = pymongo.MongoClient('localhost', 27017)
 
# Name of the database
mydb = my_client["gfg"]
 
# Name of the collection
mynew = mydb["names"]
 
for x in mycol.find():
    print(x)


Output : python-mongodb-find-2 The second parameter to the find() method is that you can specify the field to include in the result. The second parameter passed in the find() method is of object type describing the field. Thus, this parameter is optional. If omitted then all the fields from the collection/database will be displayed in the result. To include the field in the result the value of the parameter passed should be 1, if the value is 0 then it will be excluded from the result. 

Example: Return only the names and address, not the id: 

python-mongodb-3

Output: 


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!