I have a page where I only select the rows from my database that are in a particular month/year. The variable sent to each page is in YYYY-MM format.

To do my select query, I just did:

DATE_FORMAT(video.date,'%Y-%m') = '2009-12'

It works fine, I'm just making sure that this isn't too resource intensive. Is there a better way that uses less resources in the query?

THx
Ryan