7:03 PM
Subject: Re: Select statement with decimals as a record...
> Todd, this result is perfectly correct if they are both strings:
>
> "52.50" is greater than "358". To make them interpreted as
> numbers instead, see the manual page:
>
> http://www.mys
Todd, this result is perfectly correct if they are both strings:
"52.50" is greater than "358". To make them interpreted as
numbers instead, see the manual page:
http://www.mysql.com/doc/C/o/Comparison_Operators.html
Steve
Todd Williamsen wrote:
> I have a record that keeps track of averages
I have a record that keeps track of averages, now when I say
SELECT * FROM tblname ORDERBY 'average' DESC;
It returns the one with the largest amount of intergers...
I.E.
It will say that 52.50 is a larger number than 358, why is that? Is that a
table column setting of a datatype?
-