Pretty easy. There's a neat little argument on SELECT queries, the LIMIT argument.
For example:
SELECT * FROM table WHERE data='1' LIMIT 100
Which will limit it to 100. If you want to paginate it, you're dealing with a dynamic query. Thus, you'll want to add a page function. Lets assume that you have 900 records in a result, and want to display 100 per page. You'd have something similar to the following:
$pageNum = ((isset($_GET['page']) ? ($_GET['page']-1) : 0);
$limit = 100; //Change this to whatever you want
$query = "SELECT * FROM table WHERE data='1' LIMIT ".($pageNum*$limit).",".$limit;
And that query will paginate, depending on what the $_GET['page'] variable equals.
P.S. Make sure to read this, it'll get you acquainted with the MySQL SELECT syntax. http://dev.mysql.com/doc/refman/5.0/en/select.html
