title: MySQL: Selecting rows greater than a random number is producing strange results
body: <p>Suppose one has a table of 1000 entries.  We want to pick a random number between 1 and 1000 and return all rows with an id greater than or equal to that value.  It appears to work just fine when entering a static value.  For example</p>
  
  <pre><code>Select * From myTable
  Where id &gt;= 500
  Order by id Limit 10;
  </code></pre>
  
  <p>This returns the expected values of 500 through 509.  However, as soon as I try to replace that fixed value of 500 with a randomly generated one, things become very strange.</p>
  
  <pre><code>Select * From myTable
  Where id &gt;= floor(1 + RAND() * (1000 - 1))
  Order by id Limit 10;
  </code></pre>
  
  <p>Suddenly, it no longer returns sequential values.  The values returned are also extremely biased towards the low end.  I get results like this:</p>
  
  <pre><code>65, 80, 96, 98, 112, 114, 115, 116, 130, 131
  </code></pre>
  
  <p>Why does this happen?</p>