I'll expand on what chromatic wrote, because the LIMIT keyword can do even more than just that. :) In addition to specifying the max number of records to return, you can specify an offset of where to start in the records being returned. The syntax is

[LIMIT [offset,] rows]
[download]

So, for example, to view records 10-35, do this:

select log_id
from log_id
limit 10,25
[download]

Pretty neat! Consult the MySQL SELECT docs for more details and tips.