[elofsson]

Titta på LIMIT, http://dev.mysql.com/doc/refman/5.0/en/select.html

SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15