how to arrange mysql query results starting from a particular row -
assuming have records ids 1,2,3,4,5. how build query results returned arranged starting id number 3. eg 3,4,5,1,2
a case in order it:
select * `table` order case when id >= 3 0 else 1 end asc, id asc mysql
No comments:
Post a Comment