Special Content

Get rid of this Strict Standards warning WooCommerce: get_current_screen not working with multi language Can’t login on WordPress Force HTTPS using .htaccess – stuck in redirect loop WordPress: Ajax not working to insert, query and result data

Home Science, Programming and Technology WordPress Count Wordpress posts by year with SQL

Count WordPress posts by year with SQL

February 15, 20234 Views

placeholder

How can i count all WordPress posts published in a certain year(for eg. 2010) directly from the database using SQL?

PS: I managed to do it using the WordPress Api query_posts() function, but i would also like the sql query for it.

Post Views: 4

Leave a Reply Cancel reply

You must be logged in to post a comment.

2 comments

Anonymous says:

February 15, 2023 at 7:52 am
Assuming you are interested in the published posts:
```
SELECT COUNT(*)
FROM wp_posts
WHERE YEAR(post_date) = 2010
AND post_type = 'post'
AND post_status = 'publish'
```
where wp_posts is the default posts table name, adjust with whatever prefix you chose if you changed it.
Log in to Reply

Along the lines of

SELECT 
  COUNT(*) AS PostCount 
FROM
  PostTable 
WHERE 
  PostDate BETWEEN '2010-01-01' AND '2011-01-01'