PHP MySQL Order By keywords

The ORDER BY keyword is used to sort the data in the recordset.

ORDER BY keywords

The ORDER BY keyword is used to sort the data in the recordset.

The ORDER BY keyword sorts the records in ascending order by default.

If you want to sort in descending order, use the DESC keyword.

Grammar

SELECT column_name(s)FROM table_nameORDER BY column_name(s) ASC|DESC

To learn more about SQL, visit our SQL Tutorial.

Example

The following example selects all the data stored in the "Persons" table and sorts the results based on the "Age" column:

";}mysqli_close($con);?>

The above result will output:

Glenn Quagmire 33Peter Griffin 35

Sort by two columns

You can sort by multiple columns.When sorting by multiple columns, the second column is only used if the first column has the same value:

SELECT column_name(s)FROM table_nameORDER BY column1, column2