Hi, Your request gives this result :

region contact
Cape Town Anna
Cape Town Fred
CapeTown Joe
Durban John
Durban Mary
Johannesburg Frank

This is slightly different from the expected result. Bye

Hi Again, Oups, I didn't see the response of James H. which has found the same solution. Sorry for the noise. Bye

Hi, With this request,

SELECT region, contact FROM `localisation` ORDER BY SUBSTRING(region,2,2) DESC, contact ASC

I obtain :

region contact
Durban John
Durban Mary
Johannesburg Frank
Cape Town Anna
Cape Town Fred
CapeTown Joe

The list is ordered regarding the second letter of the region. To avoid the missing blank in CapeTown, the end of the string is cut. Bye