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