base64解码

SELECT
CAST(FROM_BASE64(微信昵称) AS CHAR CHARACTER SET utf8) as 微信昵称
FROM mcn0415

用FROM_BASE64()解码后，导出到excel的内容值可能会是乱码，所以需要用cast转换一下格式，转换成CHAR CHARACTER SET utf8 即可