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.

Answer 1

How about something like

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

Answer 2

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