mysql rand()查寻提升
摘要： SELECT * FROM `content` WHERE id = (SELECT floor( RAND() * ((SELECT MAX(id) FROM `content`)-(SELECT MIN(id) FROM `content`)) + (SELECT MIN(id) FROM `content`))) ORDER BY id LIMIT 1; ...
SELECT * FROM `content` WHERE id = (SELECT floor( RAND() * ((SELECT MAX(id) FROM `content`)-(SELECT MIN(id) FROM `content`)) + (SELECT MIN(id) FROM `content`))) ORDER BY id LIMIT 1;
