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:
The question is, how can I set the query so that it will return
how can I have mysql to insert a dollar sign before the data upon return the result?
Thank you very much in advance.
modify data on select
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users