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?