I would like a short and easy way to sort my search results by number.
Currently my table (tb_profile) contains a field called (Continents). There are ten velues in the Continent field (1, 2, 3, 4, 5, 6, 7, 8, 9, 10).
My problem is that the "order by" function does not allow you to sort by values... instead it sort either ASC or DESC.
I wish to sort the table as (1, 10, 9, 4, 5, 7, 8, 2, 3, 6).
First to send best solution to PMB gets the job.
Rgds,
GPS