mysql 随机选取

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

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

SELECT * FROM your_table WHERE id = (SELECT FLOOR(RAND() * (SELECT MAX(id) FROM your_table))) LIMIT 1;

CREATE TEMPORARY TABLE temp_ids (id INT);
INSERT INTO temp_ids SELECT id FROM your_table;
SELECT * FROM your_table WHERE id = (SELECT id FROM temp_ids ORDER BY RAND() LIMIT 1);
DROP TEMPORARY TABLE temp_ids;

SET @row := 0;
SELECT * FROM (
    SELECT (@row:=@row+1) AS row_number, t.* FROM your_table t ORDER BY id
) AS sorted_table WHERE row_number = FLOOR(RAND() * (SELECT COUNT(*) FROM your_table));