msyql 移动某一列数据到某列 字段加前缀

 #移动数据
 UPDATE dcs_organize_user AS a, dcs_organize_user AS b SET a.SHORTTELNO=b.USERTELNO WHERE a.id=b.id;

 #字段加前缀
  UPDATE dcs_organize_user SET USERTELNO=CONCAT('0038089819',USERTELNO);