mysql Support hierarchical queries--URGENT?

[rama krishna]

hi all

let me know whether mysql 4.1 supports hierarchial queries..

if yes can I have the solution for this query and also the syntax...


SELECT panrep_id FROM U_PANREP where panrep_id in
(select panrep_id from u_pr_role where role_id=1 and rp_status='A') start with PANREP_id=4 CONNECT BY PRIOR PANREP_REF=PANREP_ID;

Thanks in advance

Ramakrishna.....