Had a slight problem today and found a neat solution.
My problem was I wanted to sort properties by status and date added but needed the status to show in a priority fashion.
For example, I wanted the order of the property status to be For Sale, For Rent, Sale Agreed and also to sort by date added.
I couldnt use ORDER BY propertyStatus, propertyDateAdded because then For Rent would come before For Sale.
The solution was to use ORDER BY FIELD
Syntax: ORDER BY FIELD(propertyStatus,'For Sale','For Rent','Sale Agreed'), propertyAdded DESC
This assumes you need some order though. Another good application of this would be ordering a field where its 'HIGH','MEDIUM','LOW'