I believe this is standard SQL.
http://www.mysql.com/Manual_chapter/manual_Reference.html#SELECT
refer to the [ ASC | DESC ] portion.
From: Geocrawler.com <archiver@stripped>
To: <mysql@stripped>
Sent: Monday, August 02, 1999 8:33 AM
Subject: How to change Order of SELECT
> This message was sent from Geocrawler.com by "Martin Lilienthal"
<webmaster@stripped>
> Be sure to reply to that address.
>
> How can I change the order of a SELECT?
>
> For example (in_time is a column which contains a Timestamp-Value):
> When I try "SELECT * FROM test ORDER by in_time;"
> MySQL returns this:
> val1, val2, val3, 19990802145736
> val1, val2, val3, 19990802145737
> val1, val2, val3, 19990802145738
> val1, val2, val3, 19990802145739
>
> But I want this:
>
> val1, val2, val3, 19990802145739
> val1, val2, val3, 19990802145738
> val1, val2, val3, 19990802145737
> val1, val2, val3, 19990802145736
>
> How can I realize this?
>
> regards, Martin
>
>
>
>
>
>
>
>
> Geocrawler.com - The Knowledge Archive
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread9093@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>
