In mySQL, I would like to return a count of the records that have a
within the current year (as in the year 2012, NOT within the last one year time period) and (as a separate query) a count of the records from the previous year (2011 in the case as it is now).
My start dates are stored thus:
. I am using PHP.
Help on how I would form these queries would be hugely appreciated.