mysql> SELECT min(id),max(id) from images where foo like 'bar%'; +---------+---------+ | min(id) | max(id) | +---------+---------+ | 61893 | 62437 | +---------+---------+ 1 row in set (0.59 sec)