MySQL Forums
Forum List  »  Newbie

Re: Sort Not Handling Negative Numbers Correctly
Posted by: Felix Geerinckx
Date: May 18, 2005 09:19AM

Alan Northam wrote:

> In the table in my database I have a column of numbers ranging from -3.3 to 7.1.
> When I sort the column using (SELECT * FROM mytable ORDER BY mytable;)

Did you mean

SELECT * FROM mytable ORDER BY mycolumn;

perhaps?

What is the output of

DESCRIBE mytable;

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.