SQL Query Help

[the_myth]

Hello guys, it's me returning with a probably easy to answer question.

I'm trying to get news from a database where the news items are ordered by the newest post (where the newest post is on top). I'm using this query.

select * from news order by 'date'

The problem is that it's ordering by the oldest post on top. How can I fix this? Thanks folks.

[DeltaRho2K]

select * from news order by 'date' DESC

DESC for a descending sort order, or ASC for an ascending sort order.