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

I have two RHEL5 machines, both built & configured at the same time. Both have MySQL 5.0.45 installed and share an identical database.

So - this query returns 334 on one machine, and 0 on the other:

• SELECT COUNT(*) FROM mytable WHERE DATE(datetimefield) = '2008-05-05';

• SELECT COUNT(*) FROM mytable WHERE datetimefield LIKE '2008-05-05%';

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