MySQL Find and Replace - MySQL Snipplr Social Repository

Revision: 42251

at March 2, 2011 08:05 by nielsenrc

Updated Code

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'find this string', 'replace found string with this string');

Revision: 42250

at March 2, 2011 06:39 by nielsenrc

Updated Code

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, Ã¢ï¿½ï¿½find this stringÃ¢ï¿½ï¿½, Ã¢ï¿½ï¿½replace found string with this stringÃ¢ï¿½ï¿½);

Revision: 42249

at March 2, 2011 06:39 by nielsenrc

Initial Code

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, â€˜find this stringâ€™, â€˜replace found string with this stringâ€™);

Initial URL

Initial Description

Initial Title

MySQL Find and Replace

Initial Tags

mysql

Initial Language

MySQL