尝试使用此功能:

select * from table 
order by FIELD(Code, 'Health', 'Phone', 'Freeze', 'Hot')