MySQL Order By 📶

Sort the Result

Use the "ORDER BY" statement to sort the result in ascending or descending order. The "ORDER BY" keyword sorts the result ascending by default. To sort the result in descending order, use the "DESC" keyword.

✨ Sort Result

python

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="mydatabase"
)

mycursor = mydb.cursor()

sql = "SELECT * FROM customers ORDER BY name"

mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

⬇️ Sort Descending

Use the "DESC" keyword to sort the result in a descending order.

python

sql = "SELECT * FROM customers ORDER BY name DESC"

mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

💡 Did You Know?

You can also sort by multiple columns: ORDER BY name, address.