Re: Newbie Index Question

2002-07-26 Thread Benjamin Pflugmann
Hi. On Fri 2002-07-26 at 08:34:51 -0400, [EMAIL PROTECTED] wrote: [...] > set the dates up as DATETIME fields. However, indexing on these forces me to > specify a date and time or a range. i.e. > > where ReceivedDate = '2002-07-26 08:15:05' > > or > > where ReceivedDate >= '2002-07-26' and Rec

Newbie Index Question

2002-07-26 Thread Darrell A. Sullivan, II
I have just begun "playing around" with MySQL and I have a question about indexing on dates. Part of our system is a work flow management system and we have a table for all documents that we receive. Each document record has several dates to indicate when various processing functions have been co