On 2006-12-20 16:36:54 +0100, "strawberry" <zac.carey@gmail.com> said:

>
> Josselin wrote:
>
>> happy visitors of Paris know about the 'arrondissement', an
>> administrative division of the city... 20
>> selecting them from a city database brings them as
>>
>> 'Paris 1' , 'Paris 10' , 'Paris 11' , ..... 'Paris 19' , 'Paris 2' ,
>> 'Paris 20' , 'Paris 3' , .... 'Paris 9'
>>
>> is there any way to get them ordered as :
>> 'Paris 1' , 'Paris 2' , 'Paris 3' , .... 'Paris 9' , 'Paris 10' ,
>> 'Paris 11' , ..... 'Paris 19' , 'Paris 20'
>>
>> if not I'll sort the results after selection... :-(((
>>
>> thanks for your lights
>>
>> joss
>
> Remove 'Paris' from the arrondissement field

thanks fya but over 40'000 cities in the table only 3 have
arrondissements (Paris -> 20, Marseille -> 16 and Lyon -> 9)
which is a very very low percentage...
I assume thet tah solution is sorting raw SQL output in an array , Ruby
can do that easily...

joss