MySQL :: MySQL 5.0 Reference Manual :: 12.6.2 Mathematical Functions

The following example shows how rounding differs for exact and approximate values: mysql> SELECT ROUND(2.5), ROUND(25E-1); + + + | ROUND(2.5) | ROUND(25E-1) | + + + | 3 ...

dev.mysql.com