mysql select int as currency or convert int to currency format?
FORMAT() function: http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_format
SELECT CONCAT('$', FORMAT(val, 2)) ... ;
FORMAT() function: http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_format
SELECT CONCAT('$', FORMAT(val, 2)) ... ;