mysql随机读取数据库记录_MySQL

mysql随机读取数据库记录

Sql代码

SELECT * FROM t_room WHERE fid >=

(((SELECT MAX(fid) FROM t_room) -(SELECT MIN(fid) FROM t_room)) * RAND() +
(SELECT MIN(fid) FROM t_room)) LIMIT 10