MySQL Multiplication seems slightly weird

[eluser]Michael Wales[/eluser]
I assume rating is a FLOAT, so force MySQL to do FLOAT * FLOAT rather than FLOAT * INT:

Code:

select('rating * 20.0 AS percentage');