I’m stumped with how to combine pagination and a rand order_by from my
Let’s say I am a teacher and have a table full of test questions. I want
return a query of 20 questions and use the paginator to return 1 or 5 or
per page. The catch is I want the 20 question to be random and in random
order so they don’t keep getting the first 20 questions.
On each paginated page, the paginator performs a new query using a limit
and an offset X to return different sequential results. If I use
rand() in my query then I will get a random result, but there is a
will get a duplicate question.
Does anyone have any suggestions on how to return random results with