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

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-3) was last changed on 24-May-2017 15:30 by Hyve Support
G’day (anonymous guest) My Prefs
  • View Page Source
  • This clear IPSec security association,
    clear ipsec sa peer X.X.X.X
    

All Pages

Page views: 1923

Private Tomcat

Linux

MySQL

Email

SQL Server

ASP

JSP

C#

Web Mail

Windows Plesk

Linux Plesk

PHP

Gaming

ASP.NET

Persits ASPUpload

Wiki Help

Referring Pages:
...nobody

JSPWiki v2.8.1