Hello everybody,

I need some help with a query to count posts made in a certain year and month.
I was thinking of something like
Code:
SELECT COUNT(*)
FROM post_table
WHERE time_field >  ... AND time_field < ...
The data I have to work with is a string value formated like this: 201204
It's formated like Year Month so this would be 2012 April.
So I was kind of wondering how can I get this to work.
I'm trying to the count how maney posts where made in the year 2012 in the month April.

I can convert the string year and date by php using strtotime('201204' . '01');