Is it possible to use
ORDER BY on a TEXT format column and arrange in my preferred order and not necessarily A-Z (
ASC) or Z-A (
DESC)? Or how can it be done?
For example if I want to arrange a rating in this particular order: