Posted by Steve on 02/24/06 00:13

> Thanks. I really appreciate the quick responses. This answers the
> question perfectly. I must ask another, however. If "startdate" has
> an index on it, I've read that MySQL would not utilize that index if
> the column is located within a function -- e.g. MONTH(startdate). Is
> there any way to isolate "startdate" while still asking the same thing?

You could create 2 new columns for startmonth and startyear, computed
from startdate, and index those instead - and obviously modify your
select query accordingly.

---
Steve

[Back to original message]