MySQL "ORDER BY" Query

[Awjvail]

[sql]SELECT title, pagecount, createdat, userfriendlyname FROM $WT_DB_TemplateTable
WHERE category = 7
ORDER BY createdat DESC[/sql]

Right now, my output is in order of creation (fairly sure it is backwards too), however I would like to change "ORDER BY createdat" to make it so that it orders it in alphabetical order.

How would I do this?

[WhaLberg]

ORDER BY title.

[Awjvail]

Thanks.

Now, how would I reverse the order of them? right now they're going from Z to A.

[WhaLberg]

Sorry.

ORDER BY title ASC

[Awjvail]

Perfect.

Thanks so much.