oracle sql语法 更改为mysql sql语法 或者代码实现

问题遇到的现象和发生背景

oracle sql语法 更改为mysql sql语法 或者代码实现

问题相关代码，请勿粘贴截图

oracle sql 如下
select u.* from sup_versiontree v,SUP_UserAgentInfor u where
v.version=u.version and u.status in ('0','1') connect by prior
v.version =
v.preversion start with v.preversion=#{version,jdbcType=VARCHAR}

select u.field1,u.field2,... from sup_versiontree v,SUP_UserAgentInfor u where
v.version=u.version and u.status in ('0','1') and v.version like concat(#{version}, '%');