Replace dot with comma on SELECT
SELECT REPLACE(price, '.', ',') AS price
FROM products;
- read more about it here
You have to wrap each column you need to replace with the function. Using replace(*) is not possible.
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.