Does MySQL 5.0 support hierarchial queries?

[Mohan Rao]

Hello,

Can anyone please let me know whether MySQL 5.0 supports hierarchial queries? If so can you please give me a solution for this problem? Given below is the data:

empno name manager_id
123 mohan NULL
234 Jonn 123
345 Smith 123
456 Joe 567
567 Milan 123

It will be helpful if any one can give a query for this either in Oracle or MySQL5

I got the query in Oracle:

SELECT empno FROM table_name tbl CONNECT BY PRIOR tbl.empno = tbl.manager_id START WITH empno = "123"

Can anyone suggest the same query in MySQL 5.0?

Thanks in advance
Mohan.



Edited 2 time(s). Last edit at 10/18/2006 01:09AM by Mohan Rao.