|
|
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
Navigation:
[Reply to this message]
|