On Wed, Mar 19, 2008 at 9:42 AM, Andrew Ballard <aballard@xxxxxxxxx> wrote: > That works; I'm just wondering why you went with a count on an 'ID' column > rather than COUNT(*). ouch, it looks like im horribly wrong :O mysql> select count(*) from table; +----------+ | count(*) | +----------+ | 361724 | +----------+ 1 row in set (0.90 sec) mysql> select count(id) from table; +------------+ | count(did) | +------------+ | 361724 | +------------+ 1 row in set (4.56 sec) -nathan