Order By a field being equal to a specific value?

Question

Let's say I have this MySQL query:

SELECT * FROM A WHERE x='abc' OR y=0;

How can I prioritize the rows so that cases where x='abc' are ordered FIRST? If y=0 but x!='abc', I want those rows to come after cases where x='abc'.

Can this be accomplished with a simple ORDER BY clause?

Thanks!

Answer 1

SELECT *
FROM A 
WHERE x='abc' 
    OR y=0
order by case when x='abc' then 0 else 1 end;