I would like to replace any 'dot' character in my query string, on
SELECT DOT_TO_COMMA(*) FROM...
SELECT price, lastprice FROM products
OUTPUT: 22.10, 5.24
EXPECTATION: 22,10, 5,25
SELECT REPLACE(price, '.', ',') AS price FROM products;
You have to wrap each column you need to replace with the function. Using
replace(*) is not possible.