count how may records are AM vs. PM

[eluser]Armchair Samurai[/eluser]
I'd do it like this - retrieve two records from the table, the first being AM totals and the second PM:

Code:

SELECT COUNT(*) AS `times`
FROM `foo`
WHERE HOUR(`bar`) < 12
UNION
SELECT COUNT(*)
FROM `foo`
WHERE HOUR(`bar`) >= 12