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 Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted September 30, 2010 Share Posted September 30, 2010 ORDER BY FIELD(status, 'online', 'busy', 'away') Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.