一、客户要求身份证号取前3和后3、中间用*,于是有:
CONCAT(LEFT(SAFE_DIRECTOR_ID_CARD,3), '************' ,RIGHT(SAFE_DIRECTOR_ID_CARD,3)) as idcard
二、然后发现如果字段没有身份证号会显示“************”,这肯定不行,于是先判空再处理;
IF((SAFE_DIRECTOR_ID_CARD is null or SAFE_DIRECTOR_ID_CARD='' ) ,'',CONCAT(LEFT(SAFE_DIRECTOR_ID_CARD,3), '************' ,RIGHT(SAFE_DIRECTOR_ID_CARD,3))) safeDirectorIdCard,