Example
Format the number as “#,###,###.##” (and round with two decimal places):
SELECT FORMAT(250500.5634, 2);
Definition and Usage
The FORMAT() function formats a number to a format like “#,###,###.##”, rounded to a specified number of decimal places, then it returns the result as a string. Continue reading MySQL FORMAT Function