MySQL. How to make a selection / sorting?

Question

MySQL

Hello! Please tell me how to organize the sample.
There is a table (for example)
id name upc
1 a1 new
2 a2 new
3 a3 old
4 a4 action
5 a5 old
When selecting all records, how to do it correctly so that those records with upc = old are displayed first?

Answer 1

SELECT * FROM table ORDER BY upc = 'old' DESC;

Answer 2

You can even sort by multiple values:

SELECT * FROM table ORDER BY FIELD (upc, 'old', 'new', 'action') DESC