SQL Order By list of strings?

September 5, 2023 by Tarik

Try using this:

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