title: How to get random data in SQLite?
body: <p>I am trying to get a random order by using <code>Order by NEWID()</code> as the following: </p>
  
  <pre><code>public Cursor getSpecialList(String bloodCategory) {        
      SQLiteDatabase db = this.getReadableDatabase();
      Cursor cur = db.rawQuery("SELECT " + colName + " ," +
          "" + colFather + " ," +
          "" + colFamily + " ,"+
          "" + colPhone + " from " + ListInfoTable +
          " WHERE " + colBloodCategory + "='" + bloodCategory + "'" +
          " order by NEWID() ", new String[]{});    
      return cur;     
  }
  </code></pre>
  
  <p><strong>SQLite</strong> Log gives me the following error:</p>
  
  <blockquote>
    <p>No such function NEWID</p>
  </blockquote>