Results 1 to 6 of 6
Jan 25, 2010, 03:46 #1
- Join Date
- Oct 2004
- Newport Beach
- 0 Post(s)
- 0 Thread(s)
Most Efficient Way of Selecting Row by Month/Year?
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?