mysql随机取第一条数据

通用：SELECT user_id FROM dd_circle_member WHERE circle_id=2927 ORDER BY RAND() LIMIT 1 

但是效率低 下面的效率较高

 SELECT user_id FROM `dd_circle_member`
WHERE member_id >= (SELECT floor( RAND() * ((SELECT MAX(member_id) FROM `dd_circle_member`)-(SELECT MIN(member_id) FROM `dd_circle_member`)) + (SELECT MIN(member_id) FROM `dd_circle_member`)))  and circle_id=2927 
ORDER BY member_id LIMIT 1;