Mysql - Replace strings
Jump to navigation
Jump to search
Howto replace strings in mysql dynamically =
UPDATE edilines SET mea_g = REPLACE(mea_g, ',', '.');
The above will swap all ',' with '.' in the column mea_g.
UPDATE edilines SET mea_g = REPLACE(mea_g, ',', '.');
The above will swap all ',' with '.' in the column mea_g.