mysql随机获取数据

SELECT
    *
FROM
    `table` AS t1
JOIN (
    SELECT
        ROUND(
            RAND() * (
                (SELECT MAX(id) FROM `table`) - (SELECT MIN(id) FROM `table`)
            ) + (SELECT MIN(id) FROM `table`)
        ) AS id
) AS t2
WHERE
    t1.id >= t2.id
ORDER BY
    t1.id
LIMIT 1;

 

转载于:https://www.cnblogs.com/88phper/p/8651717.html