This site is hosted and sponsored by hyve.com specialists in Cloud Hosting UK and VMware Hosting. If you are interested in our services please call us for chat on 0800 612 2524

Wordpress SQL To Replace Hardcoded URLs in Posts#

UPDATE
wp_postmeta
SET meta_value = REPLACE(meta_value, 'LINKTOFIND', 'LINKTOREPLACE');
UPDATE
wp_options
SET option_value = REPLACE(option_value, 'LINKTOFIND', 'LINKTOREPLACE');
UPDATE
wp_posts
SET `guid` = REPLACE(`guid`, 'LINKTOFIND', 'LINKTOREPLACE');
UPDATE
wp_posts
SET post_content = REPLACE(post_content, 'LINKTOFIND', 'LINKTOREPLACE');
UPDATE
wp_contact_form_7
SET mail= REPLACE(mail, 'LINKTOFIND', 'LINKTOREPLACE');
UPDATE
wp_contact_form_7
SET mail_2 = REPLACE(mail_2, 'LINKTOFIND', 'LINKTOREPLACE');
UPDATE
wp_wp_super_edit_options
SET value = REPLACE(value, 'LINKTOFIND', 'LINKTOREPLACE');
UPDATE
wp_wp_super_edit_users
SET editor_options = REPLACE(editor_options, 'LINKTOFIND', 'LINKTOREPLACE');

Back to Wordpress