liamoco Posted September 30, 2010 Share Posted September 30, 2010 I have a field called status and within this field can only be "online", "busy" or "away" how can I order my results showing the online users first, then busy and finally away. Thanks Link to comment https://forums.phpfreaks.com/topic/214864-order-by/ Share on other sites More sharing options...
PFMaBiSmAd Posted September 30, 2010 Share Posted September 30, 2010 ORDER BY FIELD(status, 'online', 'busy', 'away') Link to comment https://forums.phpfreaks.com/topic/214864-order-by/#findComment-1117757 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.