In the following simple solution, I will show you how to replace all global occurrences of a URL link (or any other text) within your WordPress post content using SQL Search and Replace Query from phpMyAdmin. This is useful if you need to change a link or text that might appear in more than one post, without going in and manually editing each post by hand to reflect the new link or text.
In the following simple solution, I’ll show you how to Search and Replace SQL database information from PhpMyAdmin. This SQL query method is extremely helpful when you need to replace multiple text strings and do not wish to export the entire database just to make those changes. With the SQL Search and Replace (SQL Query Method) the database changes can be made instantly on the fly.
The following article explains how to turn off WordPress trackbacks and pingbacks. In most cases, a WordPress Blog author might decide to disable comments if they are getting an overwhelming amount of spam. However, sometimes the spam can still get through in the form of trackbacks or pingbacks, enabling an abusive user to spam links as comments on the affected blog. Luckily this feature can be easily turned off and or totally eliminated entirely from your WordPress blog in just a few steps.
With WordPress, you can globally disable comments, if you do not want to allow comments to be placed on your blog. Since this information is stored in the database, we can edit the allow comments option (open or close comments) across the entire blog in one step. This tutorial explains how to remove all instances of Allow Comments by using an SQL database query.