(I used to have separate date/time cols. in all tables
but changed them to datetime and buggered up some stuff.
Now I'm trying to find the best way to fix this.)
If I have an indexed datetime column (`date`), and say:
select date, <other_cols>
from table1
where date between '2005-08-01' and '2005-08-14'
order by date;
Can the index ever be used in a date-only where clause
or must I include the time part also?
Explain does show the index in possible_keys, but is not
shown under key. (Very little data in this table).
Thanks,
Jon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
