note
pdcawley
And there was me thinking it was:
<code>
SELECT * FROM table
LIMIT 99, 21;
</code>
No <tt>WHERE</tt> clause in sight. If you want be be a bit more specific on how things are ordered (rather than insertion order (which I believe is defined as being the standard ordering)), you do
<code>
SELECT * FROM table
ORDER BY col
LIMIT 99, 21;
</code>
Still no <tt>WHERE</tt> clause.
162771
162971