Is complex sorting with a condition possible in MySQL?

Question

MySQL

There is a field by which you need to sort, but not quite in order, i.e. it should look something like this: 1;1;1;2;4;3;2;4;3;5;5;…
1 - at the beginning, and then - as it will. those. display a certain value "up".
And the rest of the data that would be sorted later and by other fields?
At the moment I have full sorting by several fields separated by commas in ORDER - and it turns out like this:
1 | a
1 | Z
2 | a
2 | Z
3 | a
3 | Z
And you need this:
1 | a
1 | Z
2 | a
3 | a
2 | Z
3 | Z
(Both fields are varchar, utf-8)
I know the variant with the introduction of one more field, according to which sorting is going on. A complex SELECT is also not needed. Interested - is it possible to make one SQL query, maybe there is some kind of standard workpiece?
MySQL 5

Answer 1

Look towards ORDER BY FIELD(...)

Answer 2

You can also write CASE WHEN in ORDER