Skip to content

Instantly share code, notes, and snippets.

@basilesimon

basilesimon/gist:2526cd881068a7559c8082fd06b3fafe

Created June 1, 2016 18:04
Show Gist options
  • Save basilesimon/2526cd881068a7559c8082fd06b3fafe to your computer and use it in GitHub Desktop.
Save basilesimon/2526cd881068a7559c8082fd06b3fafe to your computer and use it in GitHub Desktop.
Download ZIP
SQL - Wordpress Word Count across *all* pages
Raw
gistfile1.txt
SELECT SUM(LENGTH(post_content) - LENGTH(REPLACE(post_content, ' ', '')) + 1) as 'Word Count' FROM `wp_posts` WHERE post_status='publish' AND post_type='page';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment