yanknudtskov
1/8/2016 - 9:01 AM

Search Replace for WordPress Beware using the last query, as it may interfere with serialized strings

Search Replace for WordPress

Beware using the last query, as it may interfere with serialized strings

search_replace_for_wordpress.sql
content_copyfile_download
update wp_PREFIX_posts set guid = replace(guid, 'SEARCH_STRING', 'REPLACE_STRING') where instr(guid, 'SEARCH_STRING') > 0

//Find values ending without '/'
// This one is for site_url and home_url
update wp_PREFIX_options set option_value = replace(option_value, 'SEARCH_STRING', 'REPLACE_STRING') where instr(option_value, 'SEARCH_STRING') > 0

// Find values ending with '/'
update wp_PREFIX_options set option_value = replace(option_value, 'SEARCH_STRING/', 'REPLACE_STRING/') where instr(option_value, 'SEARCH_STRING/') > 0