> SELECT count(id) > FROM tblTabel > WHERE fieldName != '' AND > ( > myDateField >= 20011120000000 AND > myDateField < 20011130000000 > );
Thank you, that was defiantly part of the solution! I had created an index on both fieldName og myDateField, but MySQL did not use that. But creating an index only on myDateField did the trick. Thanks for the help! Mvh 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
