Search & Replace in MySQL DB - SQL Snipplr Social Repository

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