More than a dozen useful WordPress database queries
Secure, clean up, and optimize your blog with 10 “life-saving” SQL queries from Cats Who Code. Most of them are short and should work by simply copying & pasting them into your database manager. Here’s what you can do:
- Manually change your password
- Transfer posts from one user to another
- Delete post revisions and meta associated to those revisions
- Batch delete spam comments
- Find unused tags
- Find and replace data
- Get a list of your commentators emails
- Disable all your plugins at once
- Delete all tags
- List unused post meta
- Disable comments on older posts
- Replace commentator url
- Replace commentator email adress
- Delete all comments with a specific url
The article also recommends an SQL WordPress plugin so you don’t have to go anywhere else to execute the queries. If you’re not familiar with SQL, the best way to learn is by example! As a precautionary measure, however, make sure to have a database backup ready before doing any database manipulation.
Related Posts
- Previous post: New features in WordPress 3.0
- Next post: WordPress Plugin: BuddyPress Template Pack
