Skip to content

MySQL

Migrating a Yoast meta description to a WordPress post excerpt

By Chris Aram / April 24, 2019 /

Yoast is a helpful WordPress plugin, but I prefer to use the WordPress excerpt to generate a meta description. Here’s a quick bit of SQL to convert historical Yoast meta to the WordPress excerpt.

Read More

Export a list of all pages or posts containing content in WordPress

By Chris Aram / April 18, 2019 /

Recently, I needed to obtain a list of all WordPress pages or posts to which a Gravity Form had been published, in order to ensure that our caching plugin wasn’t interfering with them. SELECT * FROM `wp_posts` WHERE post_content LIKE ‘%[gravityform%’ AND post_status = ‘publish’ AND post_type IN( ‘page’, ‘post’ )

Read More

Export a list of posts, tags and categories from WordPress

By Chris Aram / April 8, 2019 /

This complex SQL query can generate a complete table of your WordPress posts, plus a comma-separated list of both categories and tags.

Read More

Export a list of WordPress users from MySQL

By Chris Aram / April 8, 2019 /

Need to pull a list of your users from WordPress, but don’t want to fiddle around with test-driving a dozen plugins? You can use this quick SQL statement to obtain a complete export.

Read More

Creating a WordPress admin user in the database

By Chris Aram / March 3, 2018 /

If you need access to a WordPress site and have access to the database, this quick bit of SQL is the simplest way to create an administrator-privileged user.

Read More