[SOLVED] 101000 --> 101,000 (i.e. big numbered currency)

[Lokolo]

Currently in my DB table i store the funds as a numeric so 1000, or 101000 - but how do I put a comma in?

 

Simple as really but no idea how to do it heh.

 

thanks,

[paul2463]

FORMAT(X,D)

Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. If D is 0, the result has no decimal point or fractional part.

mysql> SELECT FORMAT(12332.123456, 4);

        -> '12,332.1235'

mysql> SELECT FORMAT(12332.1,4);

        -> '12,332.1000'

mysql> SELECT FORMAT(12332.2,0);

        -> '12,332'

 

with compliments of the <a href="http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_format"> MYSQL MANUAL </a>

[Lokolo]

oh nice one, guess i gotta learn those good old string functions...