Simply run the following SQL query on your WordPress database, using the command line client or PhpMyAdmin. In this example, I assume the unused shortcode is [tweet].
Don’t forget to backup your database before using this query.
UPDATE wp_post SET post_content = replace(post_content, ‘[tweet]‘, ” ) ;
If you like to know more about WordPress SQL queries, you should have a look to this article.
Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for free!WordPress tip: Get rid of unused shortcodes
1720 readersDo you use trackbacks and pings? Many people find them useless and asked me how they can get rid of them. Sure you can close trackbacks post by post, but this will consume a lot of time. Or you can use a good old SQl query, as shown in this article.Looking for WordPress hosting? Try
1962 readersWordPress have a feature which saves various copies of your posts in order to allow you to compare revisions or restore an older version of your posts. This is very useful, but it also take a lot of space in your database. Here is a very handy SQL query that will instantly delete all posts
2103 readersA useful tool to have in in your WordPress toolbelt is the ability to quickly and easily search for, find, and replace specific strings of text directly from the MySQL database. We can do this by entering SQL queries either directly or through one of those handy interface applications like phpMyAdmin, which seems like one
1731 readersIn WordPress, changing themes are easy. But what when you have to change a theme programmatically? Just read the following recipe to find out. It's a lot easier than you may think!Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for free!WordPress trick: Change theme programatically
1844 readersThe .htaccess file have lots of possibilities. Today, let's see how we can protect our WordPress blog from scripts injection, and unwanted modification of _REQUEST and/or GLOBALS. Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for free!Protect your WordPress blog using .htaccess
1318 readersIn order to help your visitors finding your best content, bloggers often display their most commented posts on their blog's sidebar. In this recipe, I'll show you how you can get most commented posts along with their related thumbnail.Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try
2290 readersMany plugins are made of only *.php files and most of the time they do allow direct access. Depending on what's in your files that might be a potential security hole. Today's tip will show you how to prevent direct access to plugin files.Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month
1683 readersIf like me, you often display some code on your blog, there's a strong chance that you'll enjoy today's recipe: This handy piece of code will automatically replace all content within <pre> and </pre> tags by html entities.Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for
1948 readersWordPress 3.0 will allow you to create custom post types, so what about being able to list those custom types on your blog homepage? This very useful piece of code will show you how you can do it.Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for
1764 readersFor some reason, you may want to be able to automatically display a custom text below each of your posts. You can hard-code it, but it will be way better to do so using a WordPress hook. Here's how to do.Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can
4,593
Curious what others are searching for? Below are the most popular search terms over the last 30 days.

