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.
Details to come.
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’ )
Recently, I wrote a scraper app which fetches a series of pages, pulls all of the <img /> tags into a list and then downloads them to the user’s computer. (Back story: we often work with clients who want to transfer their website away from a closed-source provider like Squarespace. These providers often do not…
WordPress provides a vast array of filters with which you can modify the content that gets written to the generated HTML; many theme and plugin authors introduce additional filters of their own. While you can readily filter primary post or page content with the_content, what happens if you need to filter the entire output generated…
This complex SQL query can generate a complete table of your WordPress posts, plus a comma-separated list of both categories and tags.
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.