Mysql format numbers with comma | mysql number format | Mysql number comma format | Mysql number format with currency symbol

Mysql 5.6 & above Versions supported

+---------------------------------------------+
| select format(123456789.32, 2, 'ta_in') |
+---------------------------------------------+
| 12,34,56,789.32                                  |
+---------------------------------------------+

SELECT FORMAT(123456789.32, 4);

 

Mysql 5.5 below versions

SELECT REPLACE(REPLACE(REPLACE(FORMAT(123456789.5,2),
'.', ':'), '.', ','), ':', '.') AS format

 

Mysql number format with currency symbol

SELECT IfNULL(CONCAT('Currency Symbol ',format(3242384723.88,2, 'ta_in')),0)