Update database fields with search replace word - MySQL Snipplr Social Repository

Revision: 52576

at October 26, 2011 23:50 by carouselcreative

Initial Code

UPDATE `table` SET fieldname = replace( fieldname, "fromthis", "tothis" )

Initial URL

Initial Description

Used to update a database field using search replace.

Initial Title

Update database fields with search replace word

Initial Tags

search, replace, update

Initial Language

MySQL