Advanced Search

Return to Snippet

Revision: 47283
at June 4, 2011 04:00 by iroybot
Updated Code 
UPDATE tablename SET fieldname =
replace(fieldname, searchstring, replacestring);

;example changing domain in wordpress posts

UPDATE wp_posts SET post_content =
replace(post_content, 'www.domain.de', 'domain.com');

Revision: 47282
at June 4, 2011 03:59 by iroybot
Updated Code 
UPDATE table SET field =
replace(field, searchstring, replacestring);

;example changing domain in wordpress posts

UPDATE wp_posts SET post_content =
replace(post_content, 'www.domain.de', 'domain.com');

Revision: 47281
at June 4, 2011 03:58 by iroybot
Initial Code 
UPDATE tabellenname SET feldname =
replace(feldname, suchstring, ersatzstring);

;example

UPDATE wp_posts SET post_content =
replace(post_content, 'www.domain.de', 'domain.com');
Initial URL 









Initial Description














Initial Title





Search and Replace in MySQL Databases









Initial Tags





mysql, sql, search, replace









Initial Language





SQL