how to make a random selection from database

Question

i am making a n application based on quiz therefore i need to select data randomly from database i m using sqlite please help

Answer 1

SELECT * FROM table ORDER BY RANDOM()

Answer 2

You should check RANDOM() function, ex:

SELECT * FROM table ORDER BY RANDOM() LIMIT 1;

Answer 3

Select * from Table order by random()

Answer 4

This seems to be a duplicate or at least related to this.

Answer 5

To minimise hits on the database, I would suggest reading out all of your questions into a data structure in memory (assuming there's not so many that it would consume all memory).

You could then shuffle the array using a decent shuffle algorithm and pop questions from the array to use.