Custom Sort order for a field in MySQL

MySQL fields are made to order alphabetically or numerically on fields, but what happens if you have a custom sort order? You might ask, but when would you have a custom sort order? The two situations that come to mind are when a field contains data NOT in the expected format. Imagine a field with …