Return to Snippet

Revision: 27023
at May 20, 2010 06:37 by iroybot


Initial Code
UPDATE table SET fieldname =
replace(fieldname, 'search', 'replacewith');

Initial URL
http://jowra.com/journal/2006/03/suchen-und-ersetzen-in-mysql-datenbanken

Initial Description
SQL to alter field contents. linked article is in german.

Initial Title
Search & Replace in MySQL DB

Initial Tags
mysql, sql, search, replace

Initial Language
SQL