Paging in MySQL query

[dacky]

hi im using MySQL database. Is it possible to page when you retrieve records from the database? Like for example i have 1000 records, I would like to view the first 100 then when i click another button i would like to view the next 100(101-200) and so on and so forth until it will reach 500. I hope anyone can share ideas.

thanks,
dacky