MySql query ORDER BY two columns

You can order by multiple columns in mysql.
The first order take first preference and then second one get next preference in mysql.

Example:

ORDER BY created_date ASC, updated_date DESC

Statement lik:

ORDER BY created_date, updated_date DESC

will sort both columns descending.

If specified each column ASC or DESC, first order will take first preference and then second one get next preference in mysql

By Keenlio, January 24, 2014