Fetch only N rows at a time (MySQL)

I'm looking for a way to fetch all data fro开发者_JAVA百科m a huge table in smaller chunks.

Please advise.

---

To answer a question from the title
use LIMIT operator

SELECT * FROM table LIMIT 0,20

as for one from body, it's too broad to ask for a certain code example, doesn't it?