Best field type for number decimal

[Mutley]

I've tried INT but it removes the decimal, I'm wanting to do a SQL query so when I order by that field it does like so:

 

12.4

12.1

11.3

9

5.4

5

4

 

But with a Varchar it puts the highest numbers with more than 1 digit at the bottom, same with char.

 

Which is best to use?

 

 

[rhodesa]

i think you are looking for DECIMAL

 

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html