Wordpress Mysql Query tutorials and examples

WordPress keeps the post meta values in wp_postmeta table. When a post is deleted, its meta data may become orphan. It is harmless data but read more

In case you are are using Yoast plugin for SEO and using it to enter meta post description, you can query meta descriptions of all read more

It can be sometime handy to query recently modified (last month or last few days) posts in wordpress mysql tables. Here are some handy queries: read more

We’ll bulk add a tag to all posts in a category as a simple use case. But this approach can be modified to handle other read more

WordPress mysql query to dump all categories (id, slug, name, description, count) SELECT wp_terms.term_id, wp_terms.slug, wp_terms.name, wp_term_taxonomy.description, wp_term_taxonomy.count FROM wp_term_taxonomy join wp_terms on (wp_term_taxonomy.term_id = read more

Sometimes we need to dump all post with featured images along with post title and image title. Here is mysql query which lists all posts read more

WordPress mysql query to display all tags (id, slug, name, description, count) SELECT wp_terms.term_id, wp_terms.slug, wp_terms.name, wp_term_taxonomy.description, wp_term_taxonomy.count FROM wp_term_taxonomy join wp_terms on (wp_term_taxonomy.term_id = read more

Find term_taxonomy_id for a category name Use the following query to find term_taxonomy_id for a category name after replacing “Tutorials” with the category you want read more

Mysql query – Find term_taxonomy_id from category name Use the following query to find term_taxonomy_id for a category name after replacing “Tutorial” with the category read more

Mysql query – Find term_taxonomy_id for a tag name Use the following query to find term_taxonomy_id for a tag name after replacing “PHP” with the read more

Handy mysql query to get all custom keys and values for a post in wordpress. SELECT wp_postmeta.* FROM wp_postmeta JOIN wp_posts ON wp_posts.ID = wp_postmeta.post_id read more

Handy mysql query to get all posts with a missing custom field. We’ll query post_type=page for the purpose of this tutorial. You will have to read more

Handy mysql query to get all posts with a specific custom field. We’ll query post_type=page for the purpose of this tutorial. You will have to read more

Sometimes we need to migrate all mysql databases to a new machine. This can be the case when you are migrating your multiple wordpress blogs read more