This doesn't work.. what is the alternative?
Code:
...
SET  price = "select price from table"; //return 5
SET fprice = "select concat('$', price); //just setting in "$"
...
how would i achive the desired result?