Mysql - Replace strings

From Skytech
Revision as of 13:31, 11 September 2009 by 212.37.141.188 (talk)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.