SELECT id,
case
WHEN CHAR_LENGTH(phone) = '11 ' THEN REPLACE(phone,SUBSTR(phone,4,4),'****')
WHEN CHAR_LENGTH(phone) = '6 ' THEN REPLACE(phone,SUBSTR(phone,4,4),'***')
WHEN CHAR_LENGTH(phone) = '7 ' THEN REPLACE(phone,SUBSTR(phone,4,5),'****')
WHEN CHAR_LENGTH(phone) = '8 ' THEN REPLACE(phone,SUBSTR(phone,4,6),'*****')
ELSE phone
END
from phone
ORDER BY id