More than a dozen useful WordPress database queries

| March 1, 2010 | Leave a Comment

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:

  1. Manually change your password
  2. Transfer posts from one user to another
  3. Delete post revisions and meta associated to those revisions
  4. Batch delete spam comments
  5. Find unused tags
  6. Find and replace data
  7. Get a list of your commentators emails
  8. Disable all your plugins at once
  9. Delete all tags
  10. List unused post meta
  11. Disable comments on older posts
  12. Replace commentator url
  13. Replace commentator email adress
  14. 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

Tags: , , , , , , ,

Leave a Reply