How to assign SQLite databse value to buttons by random
<p>I have a database with 6 column: id, question, answer1, answer2, answer3, answer4 And 10 row</p>

<p>I want to assign randomly question to a textview and answer_1,2,3,4 to 4button
how can I do that?</p>

<pre><code>public String getRandomQustion() {
    Cursor c = mydb.query("content" + " ORDER BY RANDOM() LIMIT 1", 
        new String[]{ "question" }, 
        null, null, null, null, null);
    if (c.moveToFirst()) { 
        return c.getString(c.getColumnIndex("question"));
    }     
    else { 
        return "nothing"; 
    }
} 
</code></pre>