bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/Python/Databases in Python
Python•Databases in Python

Python MongoDB Sort

Sort the Result

Use the sort()

method to sort the result in ascending or descending order.

The sort()

method takes one parameter for "fieldname" and one parameter for "direction" (ascending is the default direction).

Example

Sort the result alphabetically by name:

Formula

import pymongo myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["mydatabase"]
mycol = mydb["customers"]
mydoc = mycol.find().sort("name")
for x in mydoc:
print(x)

Sort Descending

Formula

Use the value - 1 as the second parameter to sort descending.

sort("name", 1) #ascending sort("name", -1) #descending

Example

Sort the result reverse alphabetically by name:

Formula

import pymongo myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["mydatabase"]
mycol = mydb["customers"]
mydoc = mycol.find().sort("name", - 1)
for x in mydoc:
print(x)

Previous

Python MySQL Order By

Next

Python MySQL Delete From By