mysql> select min(accesslog_id) from accesslog where accessdate >= "2004-01-01 00:00:00"; +-------------------+ | min(accesslog_id) | +-------------------+ | 3127136 | +-------------------+ 1 row in set (2 min 26.32 sec)