Formatting money values in mySQL

[Hughes]

I have a table that contains numeric values. These values actually correspond to dollars and cents. Does mySQL have a function that will format the values (i.e., 2000000) to a traditional dollar/cents format (i.e., $2,000,000).

[YappyDog]

PHP might. See if your system has the money_format() function.

http://us3.php.net/manual/en/function.money-format.php

[Hughes]

Thanks for the tip. However, I want to keep this completely contained in the SQL. Any thoughts?

[YappyDog]

I poked around the MySql manual a bit. The closest thing I see is the format function. It might work for you.

http://www.mysql.com/documentation/mysql/bychapter/manual_Functions.html#Miscellaneous_functions

[Hughes]

Thank you Yappy. For anyone looking the solution to this problem, here it is:

select concat('$',format(moneyfld,2)) as formattedmoneyfld