Get random record in SQLite

Question

I fetch records in my SQLite database like this.

Click to copy

spellId = extra.getString("spellId");
DBase db = new DBase(this);
db.open();
String[] data = db.getRecord(Integer.parseInt(spellId));
db.close();

Can I get random data like this without using raw queries and cursor?

Answer 1

try like this:

Click to copy

db.rawQuery("SELECT * FROM mainTable ORDER BY RANDOM() LIMIT 1", null);