Typically, you would do that using the LIMIT clause, which can take 2 arguments the first being the offset of the first record to return, and the second being the number of records to return.
This would return the first 15 records from yourTable:
<pre>SELECT * FROM yourTable LIMIT 0,15;</pre>
And this would return records 16-30:
<pre>SELECT * FROM yourTable LIMIT 15,15;</pre>