What come alfabeticly after letters ?

[MichaelHe]

I am listing some word from a database, and need one specific word be be listed at the end in each category.
How do I get all the other words to be listed alfabeticly but this word to be last.

I have tried with all kinds of signs before word like
..the word
-the word
_the word

and so on, but they all come first in alfabetic order.
Isn't there any signs that a normal MySQL ORDER BY line is puts after letters ?

Michael

[thorpe]

no there isn't. letter will always come first. you might need to do it in two queries.

[Lars_Berg]

order by case when wordColumn = '<wordToBeSortedLast>' then 1 else 0 end,
wordColumn

[MichaelHe]

Thank you Thank you Thank you
It works.

Now I can sleep again :o)