mysql隨機讀取數據庫記錄

mysql隨機讀取數據庫記錄   Sql代碼     www.2cto.com   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