mysql> select min(accesslog_id) from accesslog where accessdate >= "2004-06-01 00:00:00"; +-------------------+ | min(accesslog_id) | +-------------------+ | 12700047 | +-------------------+ 1 row in set (14.72 sec) mysql> select min(accesslog_id) from accesslog where accessdate >= "2004-06-07 00:00:00"; +-------------------+ | min(accesslog_id) | +-------------------+ | 13419582 | +-------------------+ 1 row in set (1.41 sec)