正则表达式-regexp_replace

最新推荐文章于 2024-10-01 07:45:37 发布

扎马尾的女孩

最新推荐文章于 2024-10-01 07:45:37 发布

阅读量526

点赞数

文章标签：正则表达式前端后端

本文链接：https://blog.csdn.net/q2842360795/article/details/122827766

版权

regexp_replace JSON 字段替换正则表达式数据库查询

关键词由CSDN通过智能技术生成

regexp_replace字符串替换函数

profile的值:
-- {"nickname":小王,"avatarurl":"","gender":"0","city":"","province":"","country":""}

select regexp_replace (profile,'({"nickname":)(.*?)(,)','$1null$3')
from csig_th_datacenter_yidian_dw::dws_user_alluser_d where profile<>'';
结果：{"nickname":null,"avatarurl":"","gender":"0","city":"","province":"","country":""}

select regexp_replace (profile,'({"nickname":)(.*)(,)','$1null$3')
from csig_th_datacenter_yidian_dw::dws_user_alluser_d where profile<>'';
结果{"nickname":null,"country":""}