Select Query with multiple months

[robs0077]

Looking for a way to run a select query with a count and group by that would break the results out by month as well as catagory. I am using this query, I would like to have 1 query that would do this for each month. Is there a way to do this with out running it 12 times and changing the dates?

SELECT catagory, COUNT( * ) AS tot
FROM crm_rsp
WHERE opn_date
BETWEEN '2003-03-01' AND '2003-03-31'
GROUP BY catagory LIMIT 0, 30

[nnichols]

Try this -

SELECT MONTH(opn_date) AS month, catagory, COUNT( * ) AS tot 
FROM crm_rsp 
WHERE opn_date 
BETWEEN '2003-01-01' AND '2003-12-31' 
GROUP BY MONTH(opn_date), catagory