mysql: is there any way we can fetch records in different order than stored order?

Question

We have following table with columns: CategoryId | CategoryName with CategoryId as primary-key.

We have following data:

0   Other
1   Bumper
2   Door
3   Roof
4   Fender

I use select * from these table and i get rows in the above sequence only i.e. 0 first and 4 at last.

Is there any way I can get 0 at last? i.e. 1,2,3,4,0?

This might help https://stackoverflow.com/questions/9378613/how-to-define-a-custom-order-by-order-in-mysql — Samuel Asor, Aug 23 '17 at 15:37

ysth · Accepted Answer · 2017-08-23T16:19:48.703

2

select * from yourtable order by CategoryId=0,CategoryId

You can use arbitrary expressions in an order by clause. By first ordering by CategoryId=0, you get all records for which that is false, followed by records (obviously only one, since it is the primary key) for which it is true. Then each of those sets of records are sorted by CategoryId.

edited Aug 23 '17 at 16:19

answered Aug 23 '17 at 15:59

ysth

96,171
6
121
214

mysql: is there any way we can fetch records in different order than stored order?

1 Answers1