MySql Convert to Money

[ross1228]

Is there a way to output a "money" type in MySql?
Say I have a decimal "1234.22222", I want it displayed as "$1,234.22"

Thanks.

 

[r937]

CONCAT('$',FORMAT(daField,2))

r937.com | rudy.ca

 

[vacunita]

Although that type of formatting should be done in your front end you can do something like this in mysql to get what you want:

SELECT CONCAT('$', FORMAT(mynumberfield, 2)) as fieldalias
FROM mytable;

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.