Query all WordPress posts in MySQL not having a Yoast SEO meta description


GamesGames

If you just started using Yoast SEO it’s sometimes nice to know which posts don’t have a meta description yet. Knowing this, you can add the description which is good for your SEO results. Here is a query you can use to query all posts in WordPress not having a Yoast SEO meta description yet. You can run this on your MySQL prompt or in phpMyAdmin.

SELECT p.ID, p.post_title, pm.meta_key, pm.meta_value
  FROM wp_posts p
  LEFT JOIN wp_postmeta pm ON p.ID = pm.post_id AND pm.meta_key = '_yoast_wpseo_metadesc'
  WHERE p.post_type in ('post', 'page')
  AND p.post_status='publish'
  AND pm.meta_key IS NULL;
Code language: SQL (Structured Query Language) (sql)

The SQL query above lists all posts and pages not having a Yoast SEO meta description, because we look at WHERE ... pm.meta_key IS NULL. If you want to inspect all meta description, change it to IS NOT NULL, like this:

SELECT p.ID, p.post_title, pm.meta_key, pm.meta_value
  FROM wp_posts p
  LEFT JOIN wp_postmeta pm ON p.ID = pm.post_id AND pm.meta_key = '_yoast_wpseo_metadesc'
  WHERE p.post_type in ('post', 'page')
  AND p.post_status='publish'
  AND pm.meta_key IS NOT NULL;Code language: PHP (php)

This may come in handy to when you want to bulk review the meta descriptions of all your posts and pages.

foto van Jan Reilink

About the author

Hi, my name is Jan. I am not a hacker, coder, developer or guru. I am merely a systems administrator, doing my daily SysOps/DevOps thing at cldin. With over 15 years of experience, my specialties include Windows Server, IIS, Linux (CentOS, Debian), security, PHP, websites & optimization.

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x