MySQL Order By RAND() Alternatives
Howto speed up your SQL queries
SELECT a single random item:
SELECT @lines:=COUNT(id) FROM azn_items;
SET @rand = CEILING( RAND() * @lines );
SELECT * FROM azn_items WHERE (@rand:=@rand-1) + id = id;
SELECT @lines:=COUNT(id) FROM azn_items;
SET @rand = CEILING( RAND() * @lines );
SELECT * FROM azn_items WHERE (@rand:=@rand-1) + id = id;
Comments
Write the first comment
Leave a trace
Post being viewed right now
