my $query = qq{SELECT col1, col2, col3 FROM mytable LIMIT ? , ?}; my $sth = $dbh->prepare($query); my $lines = 20; for my $page_no (1..10) { $sth->execute($page_no, $lines); # do something with the page. }