thenbrent/gist:2832609

Created May 30, 2012 01:56

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/thenbrent/2832609.js"></script>
Save thenbrent/2832609 to your computer and use it in GitHub Desktop.

Download ZIP

Count all words in all the posts of a WordPress site via MySQL

Raw

gistfile1.sql

	SELECT SUM(LENGTH(`post_content`) - LENGTH(REPLACE(`post_content`,' ',''))+1)
	FROM `wp_posts`

scribu commented May 30, 2012

Wouldn't it be faster to calculate the number of spaces and then add 1?

thenbrent commented May 30, 2012

Author

Yes, assuming people don't do the old fashion "double space after a period". I only needed a general idea of word count (up to around 20% variation is fine) so either would be fine.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment