in reply to Re^2: How to do Pagination With Perl and mySQL
in thread How to do Pagination With Perl and mySQL

The trick is putting "LIMIT 10 OFFSET 20" to the end of your queries. The first number will be how many items per page, and the second one is how many items to skip (i.e. pages * items_per_page)

In Section Seekers of Perl Wisdom