Jump to content

modify data on select


hvle

Recommended Posts

I have a table contain a field named 'price' and it is a numeric data.
That field, as you know, hold a numeric number represent an amount of money.

when I do: "select price from table where 1"
it will return the price in numeric form:

234.30
200.00

etc.

The question is, how can I set the query so that it will return

$234.30
$200.00

instead.
how can I have mysql to insert a dollar sign before the data upon return the result?

Thank you very much in advance.
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.