[color=red]Substr(p_rodname, 1, Instr(p_rodname, '->', 1)-1)[/color]
[color=blue]eg:
select * from r_users where id=
Substr('1->For super admin', 1, Instr('1->For super admin', '->', 1)-1)
ps: p_rodname值为'1->For super admin' 截取之后变为1 [/color]
[color=blue]eg:
select * from r_users where id=
Substr('1->For super admin', 1, Instr('1->For super admin', '->', 1)-1)
ps: p_rodname值为'1->For super admin' 截取之后变为1 [/color]