处理idcard中的特殊字符

geniusbluesky

已于 2022-04-21 19:48:50 修改

阅读量1w

点赞数

分类专栏： mysql 文章标签： mysql

于 2022-04-21 17:33:03 首次发布

本文链接：https://blog.csdn.net/geniusbluesky/article/details/124327383

版权

数据清洗身份证号码 REPLACE函数数据库操作异常字符

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

mysql 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

导入数据处理idcard号码

update  person  set id_card_no = REPLACE(id_card_no ,'x','X') ;
update  jx_industry  set id_card_no = REPLACE(id_card_no ,' ','') ;

update  jx_industry  set id_card_no = REPLACE(id_card_no ,'[','') ;
update  jx_industry  set id_card_no = REPLACE(id_card_no ,']','') ;

update  jx_industry  set id_card_no = REPLACE(id_card_no ,"'","") ;

update  jx_industry  set id_card_no = REPLACE(id_card_no ,'；','') ;

update  jx_industry  set id_card_no = REPLACE(id_card_no ,'，','') ;

update  jx_industry  set id_card_no = REPLACE(id_card_no ,'','') ;

update  jx_industry  set id_card_no = REPLACE(id_card_no ,'.','') ;

update  jx_industry  set id_card_no = REPLACE(id_card_no ,'.','') ;

update  jx_industry  set id_card_no = REPLACE(id_card_no ,'　','') ;

update  jx_industry  set id_card_no = REPLACE(id_card_no ,'号','') ;

update  jx_industry  set id_card_no = REPLACE(id_card_no ,'。','') ;