MySQL query with complex sorting

Question

We have such table in MySQL: id - int; title - varchar; hd - tinyint; source - tinyint; active - tinyint;

How do i get data from database with such sorting:

1. hd >= 3 AND source <> 5
2. hd >= 3 AND source = 5
3. hd = 2
4. other, i.e. hd < 2

Please show me how to do it properly and one sql query?

Thank you.

juergen d · Accepted Answer · 2013-11-25 16:23:35Z

6

select * from your_table
order by case when hd >= 3 AND source <> 5 then 1
              when hd >= 3 AND source = 5 then 2
              when hd = 2 then 3
              else 4
         end

answered Nov 25, 2013 at 16:23

juergen d

205k40 gold badges305 silver badges377 bronze badges

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

Comments

Rahul Tripathi · Accepted Answer · 2013-11-25 16:24:03Z

4

Try this:

select * 
from table_name
order by case when hd >= 3 AND source <> 5 then 1
              when hd >= 3 AND source = 5 then 2
              when hd = 2 then 3
              else 4
         end

answered Nov 25, 2013 at 16:24

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Collectives™ on Stack Overflow

MySQL query with complex sorting

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related