On Tue, Jan 16, 2001 at 02:40:22PM -0600, Robert wrote:
> Hello. I am trying to get the results from a query to be ORDERED by
> ASCENDING instead of the default DESCENDING. Is this possible, and
> if so how?
I mis-wrote in my reply (which hasn't come thru the list yet). You can
use "ASC" but now
On Tue, Jan 16, 2001 at 02:40:22PM -0600, Robert wrote:
> Hello. I am trying to get the results from a query to be ORDERED by
> ASCENDING instead of the default DESCENDING. Is this possible, and
> if so how?
As the manual explains:
SELECT . ORDER BY foo ASC
or
SELECT . ORDER B
Hmmm, you seem to have things a little backwards as ASCENDING should be the
default order.
However, as per the manual, the following will do it
SELECT * FROM tbl_name ORDER BY col_name ASC
To sort in the opposite order
SELECT * FROM tbl_name ORDER BY col_name DESC
Regards,
Greg
>
select col1,col2 from table1 order by col1 ASC;
Please see the manual:
http://www.mysql.com/doc/S/E/SELECT.html
On Tue, 16 Jan 2001, Robert wrote:
> Hello. I am trying to get the results from a query to be ORDERED by
> ASCENDING instead of the default DESCENDING. Is this possible, and if so
>