On 21 Nov 2002, at 14:38, Hans Zaunere wrote:
> I've played around with a couple different methods, but the only way I can
> see to use the INDEX (according to EXPLAIN) is doing a query along the
> lines of:
>
> ... WHERE thecolumn BETWEEN '2002-11-17' AND '2002-11-18'
You don't explain what you don't like about using that method. If it
works, why are you still searching?
If the problem is that you don't want to have to calculate the next
date, then use
... WHERE thecolumn BETWEEN '2002-11-17 00:00:00' AND
'2002-11-17 23:59:59'
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
