MySQL Forums
Forum List  »  Oracle

Help Order by
Posted by: Fabio Castillo
Date: August 23, 2009 10:13AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Help Order by
4268
August 23, 2009 10:13AM
2385
August 26, 2009 01:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.