Like we all know, we will use SQL to replace or remove some content in our WordPress using phpMyAdmin, on this post I’ll show you how To Replace/Remove Content on Your WordPress using SQL. On this trick you’ll access trough phpMyAdmin on your server or using plugin WP-DBManager and you’ll direct access trough WordPress Admin panel.

After you install dB manager or logging into phpMyAdmin, visit Run SQL interface and try the following code:

UPDATE wp_posts SET post_content = REPLACE ( post_content, 'nofollow ', '' );

1	UPDATE wp_posts SET post_content = REPLACE ( post_content, 'nofollow ', '' );

On this sample, you may remove all content with nofollow on your post content. Please note you’ll multile SQL query too by using this method:

UPDATE wp_posts SET post_content = REPLACE ( post_content, 'nofollow ', '' );
UPDATE wp_posts SET post_content = REPLACE ( post_content, ' nofollow', '' );
UPDATE wp_posts SET post_content = REPLACE ( post_content, ' rel="nofollow"', '' );

UPDATE wp_posts SET post_content = REPLACE ( post_content, 'nofollow ', '' );

UPDATE wp_posts SET post_content = REPLACE ( post_content, ' nofollow', '' );

UPDATE wp_posts SET post_content = REPLACE ( post_content, ' rel="nofollow"', '' );

This method will the same thing but multiple queries are executed at the same time. you’ll tweak this code what ever you would like, like replace wordpress.org with wptricks.net, thus all of your content with url’s to wordpress.org are going to be replaced into wptricks.net using this technique:

UPDATE wp_posts SET post_content = REPLACE ( post_content, 'wordpress.org ', 'wptricks.net' );

1	UPDATE wp_posts SET post_content = REPLACE ( post_content, 'wordpress.org ', 'wptricks.net' );

Choose the Best WordPress Web Hosting

HostForLIFEASP.NET is recognized as one of the Best, Cheap WordPress Web Hosting Provider in UK. You can always start from their start from €3.00/month and this plan has supported WordPress, Joomla, Drupal, Umbraco, etc with one-click installer, within less than 5 minutes. They provide cheap, best and instant activation on your WordPress Hosting hosting account with UNLIMITED Bandwidth, Diskspace and Domain.