title: How to get ALL rows starting from row x in MySQL
body: <p>In MySQL, how can I retrieve ALL rows in a table, starting from row X? For example, starting from row 6:</p>
  
  <pre><code>LIMIT 5,0
  </code></pre>
  
  <p>This returns nothing, so I tried this:</p>
  
  <pre><code>LIMIT 5,ALL
  </code></pre>
  
  <p>Still no results (sql error).</p>
  
  <p>I'm not looking for pagination functionality, just retrieving all rows starting from a particular row. <code>LIMIT 5,2000</code> seems like overkill to me. Somehow Google doesn't seem to get me some answers. Hope you can help. </p>
  
  <p>Thanks</p>