regexp_replace(1,2,3,4,5,6)
语法说明:1:字段 2:替换的字段 3:替换成什么 4:起始位置(默认从1开始) 5:替换的次数(0是无限次) 6:不区分大小写
SELECT
CONCAT(LEFT(IdentityCardNo,3), ‘’ ,RIGHT(IdentityCardNo,4)) AS 身份证号
FROM c_inhabitantinfo;
----替换字符
select replace(mmformflow027field5,substr(mmformflow027field5,4,4),'’) from MB_MFORMFLOW027
字段不为空的查询
select *from MB_MFORMFLOW027 where mmformflow027field4id is not null ;