求助，oracle的connect by功能转换到mysql如何

求助，oracle的connect by功能转换到mysql如何

在Oracle中sql代码如下编写

select o.orgid from t_organization o
connect by prior o.orgid = o.orgparentid
start with o.orgid = #{params.swjgDm}

那么在MySQL数据库中需要改为如下方式

select o.orgid from t_organization o where
(o.ORGPARENTIDS LIKE concat('%/',#{params.swjgDm},'/%')
or o.ORGID =#{params.swjgDm}) and o.AVAILABLE ='1'2017-04-11

没卵用没卵用没卵用没卵用没卵用没卵用没卵用没卵用没卵用2017-04-11