SELECT * FROM table
WHERE id >= (
(SELECT MAX(id) FROM table WHERE xxx = 'xxx')-
(SELECT MIN(id) FROM table WHERE xxx= 'xxx')
) * RAND() + (SELECT MIN(id) FROM table WHERE xxx= 'xxx')
LIMIT n 你试试这样行不 利用id取 n是要取得条数
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024