sql

Show Latest Post From Each of Specified Categories

The Code below illustrates how to select the latest Post from each of a list of categories.
Continue reading

Add a Tag to each Post in a Category

A WP user had a large number of posts in a certain category.  They wanted to add a tag to each post in that category.  Here is the procedure to do that with SQL commands.  Continue reading

Useful SQL Queries

Here are some articles with SQL queries that may be useful:

13 Useful SQL Queries NOTE: this site appears to make IE8 hang.

http://wpmu.org/8-tips-for-keeping-a-squeaky-clean-wordpress-database/