What exact code to be use in randomly retrieving items in mysql?

Question

I am trying to create an examination system, wherein i have databank in mysql. I would like to randomly select questions that will be display in the textbox.

Possible duplicate of [How to request a random row in SQL?](http://stackoverflow.com/questions/19412/how-to-request-a-random-row-in-sql) — Nhan, Aug 07 '16 at 14:44

score 1 · Answer 1 · answered Aug 07 '16 at 14:27

1

You can obtain a random row this way

SELECT * FROM Your_table ORDER BY RAND() LIMIT 1

answered Aug 07 '16 at 14:27

ScaisEdge

129,293
10
87
97

Well if my answer is what you are looking for please merk it as accepted .. – ScaisEdge Aug 07 '16 at 14:45

What exact code to be use in randomly retrieving items in mysql?

1 Answers1