Find and replace a string - MySQL Snipplr Social Repository

Revision: 48617

at July 6, 2011 18:02 by springy

Initial Code

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

Initial URL

http://www.mediacollege.com/computer/database/mysql/find-replace.html

Initial Description

remove the square brackets

Initial Title

Find and replace a string

Initial Tags

mysql

Initial Language

MySQL