MySQL in a Nutshell

Name

FORMAT( )

Synopsis

FORMAT(number, decimal)

This function returns the floating-point number given with a comma inserted between every three digits and a period before the number of decimal places specified in the second argument.

SELECT FORMAT(1000.375, 2)
       AS Amount;
+----------+
| Amount   |
+----------+
| 1,000.38 |
+----------+

Notice that the function rounded the number given to two decimal places.