The following SQL retrieves the correct rows:
SELECT * FROM EVENTS WHERE MONTH( event_date ) = 11 AND YEAR( event_date ) = 2011
However, there doesn't seem to be a way to perform this kind of query using fActiveRecord; there are no suitable operators or functions to select by part of a date in Flourish SQL either.
How can I retrieve only the records where month equals X and year equals X? Any help gratefully received.