>>>>> "Chris" == Chris Trown <ctrown@stripped>
> writes:
<cut>
Chris> In my little test DB, I have at least 40,000 rows.
>> MySQL can use index on datetime, but NEVER in a function. As soon as
>> you use a function on any datatype, no index is used.q
>>
Chris> I suspected as much with functions.
Chris> Ok, so what would be the best approach if I need to search on a
Chris> particular year/month combo? Would something like
Chris> select login, start_time from foobar where start_time='1999-07'
Hi!
The following will use index on start_time
select login, start_time from foobar where start_time between
'1999-07-01 00:00:00' and '1999-07-31 23:59:59';
Regards,
Monty
