SQL字符串操作，替换身份证为掩码

SELECT
  UPPER(CONCAT( LEFT ( staffer_code, 6 ), '****', RIGHT ( staffer_code, 4 ) )) AS 身份证号 
FROM
  sys_user where TRIM(staffer_code)<>''