MySQL custom ordering

Question

I have a table which stores user login ID. Now i want to display information so tat the logged in user's ID should be on top and other should be at the bottom. For exapmle if the user ID is 3 then all the records with 3 should appear first and other records should follow the list.. How do I do this?

mechanical_meat · Accepted Answer · 2011-04-24 15:15:26Z

2

... ORDER BY CASE WHEN user_id = 3 THEN 1 ELSE 2 END ...

answered Apr 24, 2011 at 15:15

mechanical_meat

170k25 gold badges237 silver badges231 bronze badges

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

Collectives™ on Stack Overflow

MySQL custom ordering

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related