-- empleados
update employee 
set cellphone_emp = TRIM(cellphone_emp);

update employee e
set e.cellphone_emp= REPLACE(LEFT(e.cellphone_emp,1),'0',CONCAT('09',SUBSTR(e.cellphone_emp,2)))
WHERE e.cellphone_emp LIKE '03%' OR e.cellphone_emp LIKE '05%' OR e.cellphone_emp LIKE '06%' OR  e.cellphone_emp LIKE '08%' OR e.cellphone_emp LIKE '09%' ;

update employee e
set e.cellphone_emp= REPLACE(LEFT(e.cellphone_emp,1),LEFT(e.cellphone_emp,1),CONCAT('09',SUBSTR(e.cellphone_emp,1)))
WHERE e.cellphone_emp LIKE '3%' OR e.cellphone_emp LIKE '5%' OR e.cellphone_emp LIKE '6%' OR  e.cellphone_emp LIKE '8%' OR e.cellphone_emp LIKE '9%' ;

-- guardians
update guardian 
set mobile_grd = TRIM(mobile_grd);

update guardian e
set e.mobile_grd= REPLACE(LEFT(e.mobile_grd,1),'0',CONCAT('09',SUBSTR(e.mobile_grd,2)))
WHERE e.mobile_grd LIKE '03%' OR e.mobile_grd LIKE '05%' OR e.mobile_grd LIKE '06%' OR  e.mobile_grd LIKE '08%' OR e.mobile_grd LIKE '09%' ;

update guardian e
set e.mobile_grd= REPLACE(LEFT(e.mobile_grd,1),LEFT(e.mobile_grd,1),CONCAT('09',SUBSTR(e.mobile_grd,1)))
WHERE e.mobile_grd LIKE '3%' OR e.mobile_grd LIKE '5%' OR e.mobile_grd LIKE '6%' OR  e.mobile_grd LIKE '8%' OR e.mobile_grd LIKE '9%' ;

-- students
update student 
set mobile_mother_std = TRIM(mobile_mother_std),mobile_father_std = TRIM(mobile_father_std) ;

update student e
set e.mobile_mother_std= REPLACE(LEFT(e.mobile_mother_std,1),'0',CONCAT('09',SUBSTR(e.mobile_mother_std,2)))
WHERE e.mobile_mother_std LIKE '03%' OR e.mobile_mother_std LIKE '05%' OR e.mobile_mother_std LIKE '06%' OR  e.mobile_mother_std LIKE '08%' OR e.mobile_mother_std LIKE '09%' ;

update student e
set e.mobile_mother_std= REPLACE(LEFT(e.mobile_mother_std,1),LEFT(e.mobile_mother_std,1),CONCAT('09',SUBSTR(e.mobile_mother_std,1)))
WHERE e.mobile_mother_std LIKE '3%' OR e.mobile_mother_std LIKE '5%' OR e.mobile_mother_std LIKE '6%' OR  e.mobile_mother_std LIKE '8%' OR e.mobile_mother_std LIKE '9%' ;

update student e
set e.mobile_father_std= REPLACE(LEFT(e.mobile_father_std,1),'0',CONCAT('09',SUBSTR(e.mobile_father_std,2)))
WHERE e.mobile_father_std LIKE '03%' OR e.mobile_father_std LIKE '05%' OR e.mobile_father_std LIKE '06%' OR  e.mobile_father_std LIKE '08%' OR e.mobile_father_std LIKE '09%' ;

update student e
set e.mobile_father_std= REPLACE(LEFT(e.mobile_father_std,1),LEFT(e.mobile_father_std,1),CONCAT('09',SUBSTR(e.mobile_father_std,1)))
WHERE e.mobile_father_std LIKE '3%' OR e.mobile_father_std LIKE '5%' OR e.mobile_father_std LIKE '6%' OR  e.mobile_father_std LIKE '8%' OR e.mobile_father_std LIKE '9%' ;