应用场景:如银行卡号,电话号等字段,查找后四位等
参数:substr(account_no,-4)
说明:substr参数,第一个为字段,第二个为取后四位。(该参数如果为正数,则截取数字+1,字数)
select a.account_id as 主键,substr(a.account_no,-4) as 银行编号,a.account_name as 银行名称 from bp3_bank_account a where a.bank_code = '03';
应用场景:如银行卡号,电话号等字段,查找后四位等
参数:substr(account_no,-4)
说明:substr参数,第一个为字段,第二个为取后四位。(该参数如果为正数,则截取数字+1,字数)
select a.account_id as 主键,substr(a.account_no,-4) as 银行编号,a.account_name as 银行名称 from bp3_bank_account a where a.bank_code = '03';