select name,login_name,fn_getpy_1(name),fn_getpy_1(case
when instr(name,'曾')>0 then REPLACE(name,'曾','zeng')
when instr(name,'兴')>0 then REPLACE(name,'兴','xing')
when instr(name,'毛')>0 then REPLACE(name,'毛','mao')
when instr(name,'仇')>0 then REPLACE(name,'仇','mao')
else name end)||substr(login_name,instr(login_name,'@') )as new_login_name
from isc_user where name like '%毛%' or name like '%兴%' or name like '%曾%' or name like '%仇%'
亲,沙发正空着,还不快来抢?
我要评论 / 展开表单