MYSQL gets a random piece of data in the data table

Get a random piece of data from a data table with an SQL statement

--Rand () gets a random floating point number between 0 and 1--((SELECT Max (ID) from test)-(select min (id) from test)) * RAND () gets to random number--+ (select min (id) FR OM test) guarantees the number between the minimum ID and the maximum ID of the SELECT * from Test where ID >= ((SELECT Max (ID) from test)-(select min (id) from test)) * RAND () + (select min (id) from test) limit 1;--or select * from Test where ID >= ((SELECT Max (ID) from test)-(select M (ID) from test) * RAND () and ID > (select min (id) from test) limit 1;

MYSQL gets a random piece of data in the data table