title: PHP MySQL pagination with random ordering
body: <p>This is a problem with a ordering search results on my website, </p>
  
  <p>When a search is made, random results appear on the content page, this page includes pagination too. I user following as my SQL query.</p>
  
  <pre><code>SELECT * FROM table ORDER BY RAND() LIMIT 0,10;
  </code></pre>
  
  <p>so my questions are </p>
  
  <ol>
  <li><p>I need to make sure that everytime user visits the next page, results they already seen not to appear again (exclude them in the next query, in a memory efficient way but still order by rand() )</p></li>
  <li><p>everytime the visitor goes to the 1st page there is a different sets of results,  Is it possible to use pagination with this, or will the ordering always be random.</p></li>
  <li><p>I can use seed in the MYSQL, however i am not sure how to use that practically ..</p></li>
  </ol>