Date: 09/09/08 (MySQL Communtiy)    Keywords: no keywords

What is the best/fastest way to find records with datetimes having times of 00:00:00? ex: `2008-01-23 00:00:00`

Using LIKE '%00:00:00' takes a relatively long time (2 seconds looking across 500,000 records).

Source: http://mysql.livejournal.com/131436.html