in reply to
Retrieving a MySQL query in chunks
I'm not sure if it's exactly what you want, but using LIMIT should do this.
MySQL SELECT Syntax
Comment on
Re: Retrieving a MySQL query in chunks
In Section
Seekers of Perl Wisdom