Count total rows by year in MySQL

Snippet added on Jul 19, 2022 by Mike

Question:

How to count total rows by year in MySQL?

Answer:

SELECT YEAR(publish_date) as publishYear, COUNT(*) AS totalRows 
FROM article 
GROUP BY YEAR(publish_date);

Description:

If you need to create a report where data is to be represented by year, you can use the built-in YEAR() function in the GROUP BY clause.

The YEAR function returns the year for date, in the range 1000 to 9999, or 0 for the “zero” date.

Reference:

YEAR reference

Share "How to count total rows by year in MySQL?"

Related snippets:

Tags:

count by year, group by year, total by year, year, group, date, mysql

Technical term:

Count total rows by year in MySQL