Ordering results in mySQL

Ordering the results in mySQL is pretty easy.

All that you need to do is add ORDER BY and then the fieldname to your query.

For instance, imagine you are getting names from a database.

The simple query might look something like:

SELECT name FROM table

...now if you want to order them alphabetically then you need to do:

SELECT name FROM table ORDER BY name

and that's pretty much all there is to it. To reverse order, just add DESC.