Mysql - order by certain strings

Question

I have a players table. Each player has a position which is either goalkeeper, defender, midfielder or forward. I want to return all players, with forwards first, then midfielders, then defenders, then goalkeepers. Obviously, if I do:

SELECT * 
FROM  'Player' 
ORDER BY position

the defenders will be returned first....

Answer 1

Use FIND_IN_SET()

SELECT * 
FROM Player 
ORDER BY find_in_set(position,'forward,midfielder,defender,goalkeeper')