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

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' )