mysql语句随机查询数据

SELECT * FROM your_table_name ORDER BY RAND() LIMIT 1;

SELECT * FROM your_table_name ORDER BY RAND() LIMIT 5;

SELECT * FROM your_table_name WHERE RAND()< (SELECT (1/COUNT(*))*10 FROM your_table_name) ORDER BY RAND() LIMIT 5;

SELECT * FROM your_table_name ORDER BY RAND() LIMIT 1 OFFSET FLOOR(RAND() * (SELECT COUNT(*) FROM your_table_name));

CREATE TEMPORARY TABLE temp_table AS SELECT * FROM your_table_name;
SELECT * FROM temp_table ORDER BY RAND() LIMIT 5;
DROP TEMPORARY TABLE IF EXISTS temp_table;