>mysql ... which would prevent index usage. If your kind of query is > frequent and slow, you could split your DATETIME column into two > separate columns for DATE and TIME and put an index onto TIME.
Ok, thanks for the help! Regards Emil -- Emil Rasmussen http://noget.net --------------------------------------------------------------------- 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