Count entries per month?

Dialect: MySQL
I have a table with a date_created column in it. I want to count the number of entries for every month. i.e

Code:

----------|------------
jan 2006  | 12
feb 2006  | 23

Hope you can help.

Dialect: MySQL
Guys, I have found the anwer myself, put though i would post it incase its of interest to anyone else:

SQL:

SELECT MONTH(date_created), YEAR(date_created), COUNT(*)

FROM contact_requests 

GROUP BY MONTH(date_created), YEAR(date_created)

Dialect: MySQL

SQL:

SELECT monthname(date_created),year(date_created),count(*) FROM table

Actually, Gary Bennion, the group by should be:

GROUP BY YEAR(date_created), MONTH(date_created)

Otherwise you'll get unexpected results... (lots of things grouped in particular months, for example, not taking into account their proper year).

Cheers!

Amy

How would I do this if I wanted the same query between to dates and I also wanted a result count of 0 for months that does not have any entries?