title: ORDER BY random() with seed in SQLITE
body: <p>I would like to implement paging for a random set </p>
  
  <pre><code>Select * from Animals ORDER BY random(SEED) LIMIT 100 OFFSET 50  
  </code></pre>
  
  <p>I tried to set int to some integer and to some fracture. Doesn't work </p>
  
  <p>How do I seed random in sqlite?</p>
  
  <p>I am tacking a chance here with down votes because similar question already exist - <a href="https://stackoverflow.com/questions/2171578/seeding-sqlite-random">Seeding SQLite RANDOM()</a>. I just didn't get the php solution. </p>