limitby without orderby

*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?