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 id >= (SELECT FLOOR(RAND() * (SELECT MAX(id) FROM your_table_name))) ORDER BY id LIMIT 1;

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

SET @row_number = FLOOR(RAND() * (SELECT COUNT(*) FROM your_table_name));
SELECT * FROM your_table_name LIMIT @row_number, 1;