一、随机【一】条数据查询:
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
FROM
`table`
LIMIT 50
) AS t2 ON t1.id = t2.id
ORDER BY
t1.id
LIMIT 1;
二、随机【指定:5】条数据查询:
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
FROM
`table`
LIMIT 50
) AS t2 ON t1.id = t2.id
ORDER BY
t1.id
LIMIT 5;