方式1:
SELECT * FROM `userfind` order by rand() limit 5
方式2:
SELECT id FROM userfind t1 JOIN (SELECT RAND() * (SELECT MAX(id) FROM userfind) AS nid) t2 ON t1.id > t2.nid LIMIT 5;
方式2比较快
方式1:
SELECT * FROM `userfind` order by rand() limit 5
方式2:
SELECT id FROM userfind t1 JOIN (SELECT RAND() * (SELECT MAX(id) FROM userfind) AS nid) t2 ON t1.id > t2.nid LIMIT 5;
方式2比较快