FORMAT(X,D): Formats the number X to a format like '#,###,###.##' : FORMAT « String Functions « MySQL Tutorial

1. MySQL Tutorial
2. String Functions
3. FORMAT

Rounds X to D decimal places.

Returns the result as a string.

If D is 0, the result has no decimal point or fractional part.

mysql>
mysql> SELECT FORMAT(12332.123456, 4);
+-------------------------+
| FORMAT(12332.123456, 4) |
+-------------------------+
| 12,332.1235             |
+-------------------------+
1 row in set (0.00 sec)

mysql>