Sort characters in strings with mysql?

Question

I'm wondering how I can sort the characters in a string from a MySQL result. A function I could call on a string like 'letter', which would return the string 'eelrtt'. All characters would be sorted in alphabetical order.

I couldn't find a function in the MySQL docs, am I missing something or is this something that needs to be done manually? Thanks!

Answer 1

This isn't something that needs to be done all that often - so it's no surprise that it's not one of the MySQL string manipulation functions - I'm afraid you'll have to figure out a means of doing this manually, as I think you already suspected.