mysql查詢or，by怎么轉(zhuǎn)換到mysql中？
在Oracle中sql代碼如下編寫select o.orgid from t_organization oconnect by prior o.orgid = o.orgparentidstart with o.orgid = #{params.swjgDm}那么在mysql數(shù)據(jù)庫中需要改為如下方式select o.orgid from t_organization o where(o.ORGPARENTIDS LIKE concat('%/',#{params.swjgDm},'/%')or o.ORGID =#{params.swjgDm}) and o.AVAILABLE ='1'
