mysql> select score,score>7.64 from rateit_files where id=2382; +-------+------------+ | score | score>7.64 | +-------+------------+ | 7.64 | 1 | +-------+------------+ 1 row in set (0.00 sec)
I assume the problem arises because of rounding since score is of type double(4,2). Have done extensive searching of the manual and google but found no reference to this issue. Version is 4.0.16
Any help would be much appreciated.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
