Dear All, We recently upgraded from 3.23 to 4.1.
We used to use queries such as: SELECT field FROM table WHERE date_field like '2003-10-10%' (The date_field is a "datetime" field) Since we found the performance quicker than using the date functions. However this no longer works in 4.1, and the only way I can find to do the above is SELECT field FROM table WHERE YEAR(date_field) = YEAR(curdate()) AND MONTH(date_field) = MONTH(curdate()) AND DAY(date_field) = DAY(curdate()) Is there a better way, since I cant seem to find any functions to return the date_field to a date. JFYI, I have tried: SELECT ... FROM ... WHERE DATE(date_field) = curdate() according to the manual > DATE() is available as of MySQL 4.1.1. SELECT ... FROM ... WHERE CURRENT_DATE(date_field) = curdate() Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]