KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Is it possible to sort in MySQL by "order by" using a predefined set of column values ( ID ) like order by (ID=1,5,4,3) so I would get records 1, 5, 4, 3 in that order out? UPDATE: Why I need this... I want my records to change sort randomly every 5 minutes. I have a cron task to update the table to put different, random sort order in it. There is just one problem! PAGINATION. I will have visitors who come to my page, and I will give them the first 20 results. They will wait 6 minutes, go to page 2 and have the wrong results as the sort order has already changed. So I thought that if I put all the IDs into a session on page 2, we get the correct records even if the sorting had already changed. Is there any other better way to do this?
Tags (comma-separated)
Save Edits
Cancel