title: Random() in sqlite and Android sdk
body: <p>I want to extract random rows from the app sqlite database in Android. I'm aware that, with sqlite, you can select random rows with:</p>
  
  <pre><code>SELECT * FROM table ORDER BY RANDOM() LIMIT 1;
  </code></pre>
  
  <p>In the app, I have something like this</p>
  
  <pre><code>return mDb.query(TABLE, new String[] {"col1", "col2"}, null, null, null, null, "Random()", "2");
  </code></pre>
  
  <p>this is for extract two random rows in table TABLE. But it keeps returning the same rows. What's wrong wit the statement?</p>
  
  <p>Thanks</p>