Reverse order of &quot;ORDER BY&quot;

Reverse order of "ORDER BY"

markjia

I have a MySQL table for storing news updates, and I need to be able to extract the rows and display them in chronological order. I'm currently using this query:

SELECT DATE_FORMAT(DateField, '%m/%d/%y') AS DateField, NewsField FROM News ORDER BY DateField

The problem is that this would save the News from earliest to latest. I would rather the most recent news be put first. Is there anyway of doing this in the query? Or do I have to save the MySQL table is the correct order to begin with (so that it would be in the desired order even without sorting)?

warik

ORDER BY DateField DESC

-Warik