Database Custom Sort Order

Question

I want to order the role of the members. Like :

Leaders 
Co Leaders
Elders
Members

But when I use ORDER BY, it orders according to the alphabet. That is :

Co Leaders
Elders 
Leaders
Members

Is it possible to do the sorting like that?

Answer 1

You can try to ORDER with FIELD :

ORDER BY FIELD(your_field, 'Leaders' , 'Co Leaders', 'Elders', 'Members')