处理idcard中的特殊字符
处理mysql字段中的特殊字符
·
导入数据处理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 ,'。','') ;
更多推荐
已为社区贡献1条内容
所有评论(0)