specifying ORDER BY with a fixed order

[[email protected]]

I wish to do something like this:

select colA, sum(colB) from tableA
where colA in ('Cat1', 'Cat2', 'Cat5', 'Cat4', 'Cat3')
group by colA
order by ???


I want the results to BE IN THE ORDER Cat1, Cat2, Cat5, Cat4, Cat3....

Can I specify the order of the results when it is unrelated to alphabet, the resulting count, etc... basically a predecided ordering?

thanks.