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, 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? > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- Steve Rapaport World Citizen --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
