<!--表中获取随机一条title 耗时0.01s id==随机字段,最好为表id-->
SELECT * FROM `tableName` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM `tableName`)-(SELECT MIN(id) FROM `tableName`))+(SELECT MIN(id) FROM `tableName`)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 1;
<!--表中获取随机多条title num==条数 耗时0.01s id==随机字段,最好为表id-->
SELECT * FROM `tableName` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM `tableName`)-(SELECT MIN(id) FROM `tableName`))+(SELECT MIN(id) FROM `tableName`)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT num;