IF(IFNULL(phone_number,'')='','',CONCAT(LEFT(phone_number,3),'****',RIGHT(phone_number,4))) phone_number
转载于:https://www.cnblogs.com/java-le/p/6956756.html
IF(IFNULL(phone_number,'')='','',CONCAT(LEFT(phone_number,3),'****',RIGHT(phone_number,4))) phone_number
转载于:https://www.cnblogs.com/java-le/p/6956756.html