mysql随机查询5条

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

SELECT * FROM (
    SELECT * FROM your_table_name
) AS subquery 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 ASC
LIMIT 5;

CREATE TEMPORARY TABLE temp_table AS (SELECT * FROM your_table_name);
ALTER TABLE temp_table ADD COLUMN rand_id DOUBLE;
UPDATE temp_table SET rand_id = RAND();
SELECT * FROM temp_table ORDER BY rand_id LIMIT 5;
DROP TEMPORARY TABLE temp_table;