At times in MYSQL an unnatural sort is required. This article presents an easy to maintain set of tables where sorting a table in any order can be easily defined.
MYSQL Custom Field Sorting Revisited
MYSQL Custom Field Sorting
In MYSQL the sorting of recordset data can be easily setup and maintained with a few custom tables and a little thought.