> CREADE INDEX myDateField_Index > ON tblTabel > ( > DATE_FORMAT(myDateField,'%Y%m%d') > ); > > This may or may not work, but it's worth a shot, if you prefer your query in > the format it was in before.
It did not work with MySQL 3.23.32, it whould have been very nice, because i still have a problem with hours, eg.: SELECT count(id) FROM tblTable WHERE myField != '' AND ( myDateField >= '00000000230000' AND myDateField < '00000000235959' ); Wich offcourse does not work, so again i am looking for some 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