title: Does LIMIT OFFSET,LENGTH require ORDER BY for pagination?
body: <p>I have a MyISAM table with 28,900 entires. I'm processing it in chunks of 1500, which a query like this:</p>
  
  <pre><code>SELECT * FROM table WHERE id&gt;0 LIMIT $iStart,1500
  </code></pre>
  
  <p>Then I loop over this and increment $iStart by 1500 each time.</p>
  
  <p>The problem is that the queries are returning the same rows in some cases. For example the LIMIT 0,1500 query returns some of the same rows as the LIMIT 28500,1500 query does.</p>
  
  <p>If I don't ORDER the rows, can I not expect to use LIMIT for pagination?</p>
  
  <p><em>(The table is static while these queries are happening, no other queries are going on that would alter its rows).</em></p>