mysql> select round(2.232,2);+----------------+| round(2.232,2) |+----------------+| 2.23 |+----------------+1 row in set (0.00 sec)mysql> select convert(1.2323,decimal(6,2));+------------------------------+| convert(1.2323,decimal(6,2)) |+------------------------------+| 1.23 |+------------------------------+1 row in set (0.00 sec)