UPDATE bjk_customerprofile SET mobile=INSERT(mobile,2,4,'****'), Address=INSERT(Address,2,4,'****'), BankCode=INSERT(BankCode,2,4,'**********'),BankAddress=INSERT(BankAddress,2,4,'**********'),PassPort=INSERT(PassPort,2,4,'**********')
mysql把字段的后面4个文字更换为*号
最新推荐文章于 2022-06-26 19:05:39 发布