SELECT * FROM tbl WHERE id > rand(0, (select max(id) from tbl)) LIMIT 1
UNION ALL
SELECT * FROM tbl WHERE id > rand(0, (select max(id) from tbl)) LIMIT 1
UNION ALL
SELECT * FROM tbl WHERE id > rand(0, (select max(id) from tbl)) LIMIT 1
UNION ALL
SELECT * FROM tbl WHERE id > rand(0, (select max(id) from tbl)) LIMIT 1
...
А лучше хранимую процедуру, чтоб max(id) несколько раз не выбирать
|