Mysql - Replace strings

From Skytech
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.


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.