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?

Add a weigth field to your table

DarkBee
– DarkBee

2015-01-10 17:53:19 +00:00
Commented Jan 10, 2015 at 17:53 — DarkBee
– DarkBee, Commented Jan 10, 2015 at 17:53

souslov · Accepted Answer · 2015-01-10 17:53:23Z

3

You can try to ORDER with FIELD :

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

answered Jan 10, 2015 at 17:53

souslov

44.7k11 gold badges92 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Riad · Accepted Answer · 2015-01-10 17:55:12Z

0

Add a column as sort_order int(10) default 0 ;

Now put the value like sort_order = 0 where member_role = Leaders, 1 for Co Leaders and else.

then ORDER BY sort_order

answered Jan 10, 2015 at 17:55

Riad

3,8585 gold badges30 silver badges39 bronze badges

Comments

Pரதீப் · Accepted Answer · 2015-01-10 18:09:40Z

0

Use can also use Case statement to custom the order.

order by case columnname 
              when 'Leaders' then 1 
              when 'Co Leaders' then 2
              when 'Elders' then 3
              when 'Members' then 4
         End

answered Jan 10, 2015 at 18:09

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

4 Comments

Pரதீப் Over a year ago

@Strawberry - sorry didn't get you.

Strawberry Over a year ago

What advantage does this offer over FIELD()

Pரதீப் Over a year ago

@Strawberry This is just another way of doing it nothing wrong in posting another answer.

Strawberry Over a year ago

I'm not suggesting there is, am I?? Just wanted to know :-(

Collectives™ on Stack Overflow

Database Custom Sort Order

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related