MySQL: Sorting in a weird order?

[igowerf]

I have information about around 100 people stored in the MySQL database but I need to have their names sorted in a weird alphabetical order. Instead of "a, b, c, d..." I need something like "h, j, a, q..." The order was created randomly, but when I display the names, I have to use that chosen order. Is there a way to do this with MySQL?

 

[Armitage]

Add another column to the DB with the names translated according to sort order ... in your example a name starting with "Ha" would translate to "Ac" in this column. Then sort by this column.