I have a column name priority, in this column, the data consists "Very High, High, Medium, Low and etc"
how can i make a order clause acording to the Priority level?
i found from this from net, but is only applicable in SQL server... how can i modify this to suit mine?
SELECT * FROM TABLE ORDER BY COLUMN_X IN ('KK', 'AA', 'CC')
i want order by Very high, high, medium, low
how can i make a order clause acording to the Priority level?
i found from this from net, but is only applicable in SQL server... how can i modify this to suit mine?
SELECT * FROM TABLE ORDER BY COLUMN_X IN ('KK', 'AA', 'CC')
i want order by Very high, high, medium, low