title: mySQL Pagination Using Limit Retrieves Duplicate Rows
body: <p>I have a table with 116,000 rows and I want to retrieve all of these rows but in 3 separate queries using: </p>
  
  <ol>
  <li>"SELECT * FROM table LIMIT 0, 50000"</li>
  <li>"SELECT * FROM table LIMIT 1, 50000"</li>
  <li>"SELECT * FROM table LIMIT 2, 50000"</li>
  </ol>
  
  <p>I have tried this but all the queries return a result of 50,000 rows, even if the "LIMIT is 10, 50000" there is a result which is not what I want. I am only expecting 16,000 rows for the 3rd query. </p>
  
  <p>How can I accomplish this? Is my expectation of LIMIT pagination wrong?</p>