Thread: limitby without orderby

limitby without orderby

From
Henry Drexler
Date:
From: Rohan Malhotra <yourbuddyrohan(at)gmail(dot)com>
select * from items order by random() limit 5;

my basic requirement is to get random rows from a table, my where clause
will make sure I won't get same rows in repeated execution of above queries.

-- 
Regards

To clarify, you are not looking for random then yes?  as you want to run select * from items order by random() limit 5; and not get repeating values - as if you are using random you will at times get repeating values.

You are wanting to get a gradually restrictive list(excluding those results you have received previously)? So each time you run the query you are guaranteed to get a new list of 5 rows?