oracle sql判断字符串是否相同

最新推荐文章于 2024-01-26 09:30:22 发布

weixin_34087307

最新推荐文章于 2024-01-26 09:30:22 发布

阅读量1.8k

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/727394/blog/189662

版权

2019独角兽企业重金招聘Python工程师标准>>>

--后三位和前三位比较
select t.REG_ADDRESS, t.REG_ADDRESS_DETAIL from T_COMMON_001_MAIN t
where t.DATA_FROM=3 and t.REG_ADDRESS like '四川%'
and substr(t.REG_ADDRESS,instr(t.REG_ADDRESS,'市',1,1)+2,LENGTH(t.REG_ADDRESS))=substr(t.REG_ADDRESS_DETAIL,0,3)
;
--中三位和前三位
select t.REG_ADDRESS, t.REG_ADDRESS_DETAIL from T_COMMON_001_MAIN t
where t.DATA_FROM=3 and t.REG_ADDRESS like '四川%'
and substr(t.REG_ADDRESS,instr(t.REG_ADDRESS,'省',1,1)+2,3)=substr(t.REG_ADDRESS_DETAIL,0,3)
;
--后两位和前两位
select t.REG_ADDRESS, t.REG_ADDRESS_DETAIL from T_COMMON_001_MAIN t
where t.DATA_FROM=3 and t.REG_ADDRESS like '四川%'
and substr(t.REG_ADDRESS,length(t.REG_ADDRESS)-1,2)=substr(t.REG_ADDRESS_DETAIL,0,2)
;