MySQL - Order by one field until results empty then order by another field -

MySQL - Order by one field until results empty then order by another field -

i have table specimen contains field room. want order records room while room == 'f', remaining records order topography_index. how can in mysql query?

try this

select * yourtable order (case when room = 'f' 0 else 1 end),topography_index

you can replace 1 maxi number

mysql