• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MySQL: Sorting in a weird order?

I

igowerf

Diamond Member
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?
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top