Re: Ayuda para ordenar una select
Al final se ha solucioando asÃ:
select nodo
from arbol
order by
cast(substring_index(concat(nodo,'.0'),'.',1) as unsigned),
cast(substring_index(substring_index(concat(nodo,'.0'),'.',2),'.',-1) as unsigned),
cast(substring_index(substring_index(concat(nodo,'.0'),'.',3),'.',-1) as unsigned),
cast(substring_index(substring_index(concat(nodo,'.0'),'.',4),'.',-1) as unsigned),
cast(substring_index(substring_index(concat(nodo,'.0'),'.',5),'.',-1) as unsigned),
cast(substring_index(substring_index(concat(nodo,'.0'),'.',6),'.',-1) as unsigned),
cast(substring_index(substring_index(concat(nodo,'.0'),'.',7),'.',-1) as unsigned),
cast(substring_index(substring_index(concat(nodo,'.0'),'.',8),'.',-1) as unsigned),
cast(substring_index(substring_index(concat(nodo,'.0'),'.',9),'.',-1) as unsigned),
cast(substring_index(substring_index(concat(nodo,'.0'),'.',10),'.',-1) as unsigned)
;