Date: 06/25/08 (MySQL Communtiy)    Keywords: mysql, sql

"mydate" is a DATETIME field. I need to search this field with DATE input and ran into this:

mysql> SELECT COUNT(*) FROM program WHERE mydate LIKE '2008-04-22%';
+-------------------+
| COUNT(*) |
+-------------------+
| 538 |
+-------------------+
1 row in set (0.08 sec)

mysql> SELECT COUNT(*) FROM program WHERE DATE(mydate) = '2008-04-22';
+-------------------+
| COUNT(*) |
+-------------------+
| 0 |
+-------------------+
1 row in set (0.06 sec)

Source: http://community.livejournal.com/mysql/129354.html