title: Seeding SQLite RANDOM()
body: <p>Does SQLite support seeding the <strong><a href="http://www.sqlite.org/lang_corefunc.html#random" rel="noreferrer"><code>RANDOM()</code></a></strong> function the same way MySQL does with <strong><a href="http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_rand" rel="noreferrer"><code>RAND()</code></a></strong>?</p>
  
  <pre><code>$query = "SELECT * FROM table ORDER BY RAND(" . date('Ymd') . ") LIMIT 1;";
  </code></pre>
  
  <p><strong>From the MySQL Manual about <code>RAND(N)</code>:</strong></p>
  
  <blockquote>
    <p>If a constant integer argument N is
    specified, it is used as the seed
    value, which produces a repeatable
    sequence of column values. In the
    following example, note that the
    sequences of values produced by
    RAND(3) is the same both places where
    it occurs.</p>
  </blockquote>
  
  <p>If not, is there any way to archive the same effect using only one query?</p>