1、LIKE模糊匹配
issu_inst_name like concat('%',#{req.userInstName},'%')
避免sql注入的模糊匹配
<if test="req.prodtNo !=null and req.prodtNo !=''">
<bind name ='pattern' value="'%'+req.issuInstName+'%'"/>
and issu_inst_name LIKE #{pattern}
</if>
2、替换手机号中的'****'为其他数字(根据key,将****随机替换为数字)
update tb_inner_user set mobile_no = replace(mobile_no,'****',substr
('' || pr_key_id || pr_key_id || pr_key_id || pr_key_id,1,4))
where mobile_no like '%****%'
(将****替换为固定1234)
update tb_inner_user set tb_inner_user = replace(tb_inner_user,'****','1234')
where tb_inner_userlike concat('%','****','%')
3、查询时候,将手机号替换为****
select replace(tb_inner_user, substr(tb_inner_user,4,4), 'XXXX') from tb_inner_user
4、删除之前先查询是否存在(子查询)
delete from tb_intbank_dep where prodt_no =
(select prodt_no from tb_intbank_dep
where prodt_no = 1647341333641 and prodt_type='13')