remove the phone code from number 11 digits

 UPDATE vicidial_list 

SET phone_code = NULL 

WHERE LENGTH(phone_number) > 10;