Is there is any way to get the select Random Records using query from table in mySql

Question

Is there is any way to get the select Random Records using query from table in mySql.

duplicate: http://stackoverflow.com/questions/142242/what-is-the-best-way-to-pick-a-random-row-from-a-table-in-mysql — Mitch Wheat, Mar 09 '10 at 07:17

score 2 · Accepted Answer · answered Mar 09 '10 at 07:17

2

How about something like

SELECT * FROM `table` ORDER BY RAND() LIMIT 0,1;

answered Mar 09 '10 at 07:17

Adriaan Stander

score 0 · Answer 2 · answered Mar 09 '10 at 07:40

0

SELECT * FROM `table` WHERE RAND() < 0.5

change the percentage to include more or less records. add a LIMIT clause to, well, limit to a maximum number of records

answered Mar 09 '10 at 07:40

knittl

2 Answers2