Help Order by

[Fabio Castillo]

hello all,

I have a problem and not how he would deal. Make a query to a table as follows

select id from menu order by id asc

+----------+
| id |
+----------+
| 1,2 |
| 1,2,1 |<-----------------
| 1,2,1,1 |
| 1,2,1,2 |
| 1,2,10 |
| 1,2,14 |
| 1,2,2 |<-----------------
| 1,2,2,1 |
| 1,2,2,2 |
| 1,2,3 |<-----------------
| 1,2,5,1 |<-----------------
| 1,2,5,10 |
| 1,2,5,19 |
| 1,2,5,2 |<-----------------
| 1,2,5,20 |
| 1,2,90 |
+----------+

The field is text and not organized well.

How do I get my order but the list for any level?

+-------------------------------------------------+
| id |
+-------------------------------------------------+
+-------------------------------------------------+
level1, level2, level3, Level4 ,... ..., nivel n |
+-------------------------------------------------+

Thanks



Edited 2 time(s). Last edit at 08/23/2009 10:22AM by Fabio Castillo.