SQL query to find the number of WordPress posts this year!

I was compiling my year end wrap up (hits, posts, twitter followers), and I realized I did not know how many posts I created this year. I ran the following query again my WordPress database to find out.

select post_date,post_title from wp_posts where post_type = ‘post’ AND post_status = ‘publish’ AND post_date like ‘%2011-%’;

My goal was 2 a week for a year. I ended up with 116.

More on this later.

Comments are closed.