orcale中字符串包含和字数分割sql

最新推荐文章于 2023-02-22 09:59:30 发布

m0_50331102

最新推荐文章于 2023-02-22 09:59:30 发布

阅读量164

点赞数 1

文章标签： sql 数据库 java

本文链接：https://blog.csdn.net/m0_50331102/article/details/126619383

版权

获取DEMAND_CENTER_NAME字段的前两位

select DEMAND_CENTER_ID,substr(DEMAND_CENTER_NAME,1,2) as demandCenterName,sum(count(*)) over (partition by
DEMAND_CENTER_ID ) centerNum
from BUSI_INFO
where BUSI_STAGE in ('2','3','4','5','6','7')

substr(字段名称，第一位，想拿到的最后一位) as

判断该字符串是否包含传入的字段
select case when INSTR(PER_INCHARGE_ID,#{query.loginerId,jdbcType=VARCHAR})>0 then 1 else 0 end as ifReport from BUSI_CONTRACT_IN_INFO PER_INCHARGE_ID = (1512327100525838336,1510790710851928064,1514464436873199616)

query.loginerId=1512327100525838336

case when INSTR(PER_INCHARGE_ID,#{query.loginerId,jdbcType=VARCHAR})>0 then 1 else 0 end as ifReport

INSTR(字段名称,传入的内容)