Never tried it mysql, but I am led to believe that sorting based on the result of the mysql SOUNDEX function may produce the results you want. Other than that, as far as I am aware there is no way to do this in MySQL without writing a stored procedure to do it.
-Stut
-Stut:
Damn, that produces some very strange results, like:
Lucerne 7
Lucerne 1
Lucerne 3
Lucerne 2
Lucerne 8
Lucerne 9
Lucerne 12
Lucerne 10
Meersburg Castle 8
Meersburg Castle 4
Meersburg Castle 9
Meersburg Castle 12
Meersburg Castle 11
Meersburg Castle 10
Meersburg Castle 2
Meersburg Castle 3
Meersburg Castle 1
But, it was a good suggestion.
tedd
--
--------------------------------------------------------------------------------
http://sperling.com