27 Apr 2007 mySQL search and replace

Posted by Hans-Henry Jakobsen

UPDATE ´tablename´ set field = replace(field, ’searchString’, ‘replaceString’);

Tags: Database, MySQL, replace, search