Replace Content in Your WordPress using SQL

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

After you install DB manager or logging into phpMyAdmin, go to Run SQL interface and do this code

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

On this sample, you will remove all content with nofollow on your post content. Please note you can 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"', '' );

This method does the same thing but multiple queries are executed at the same time. You can tweak this code what ever you want, like replace wordpress.org with wptricks.net, so all your content with url’s to wordpress.org will be replaced into wptricks.net using this method

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

That’s all, I hope our tutorial replace or remove content on your WordPress using SQL worked for you,