UPDATE `user`
SET mobile = CONCAT(LEFT(mobile, CHAR_LENGTH(mobile) - 1) ,'1'),
idCard = CONCAT(LEFT(idCard, CHAR_LENGTH(idCard) - 1) ,'1')
UPDATE `user`
SET mobile = CONCAT(LEFT(mobile, CHAR_LENGTH(mobile) - 1) ,'1'),
idCard = CONCAT(LEFT(idCard, CHAR_LENGTH(idCard) - 1) ,'1')