SELECT * FROM Ads ORDER BY RAND() LIMIT 1
我们可以使用索引,并分解为下列语句
SELECT @row_id := COUNT(*) FROM Ads;
SELECT @row_id := FLOOR(RAND() * @row_id) + 1;
SELECT * FROM Ads WHERE ad_id = @row_id;
我们可以使用索引,并分解为下列语句
SELECT @row_id := COUNT(*) FROM Ads;
SELECT @row_id := FLOOR(RAND() * @row_id) + 1;
SELECT * FROM Ads WHERE ad_id = @row_id;