Formatting mysql output as currency

[dajo]

Is there a way to format mysql output as currency with "$" and appropriate commas in place?

Thanks