[MYSQL] 암, 복호화 하는 쿼리

암호화 예제)

INSERT INTO TB_SAMPLE (USER_SN, USER_ID, USER_NM, USER_EMAD ,USER_CPNO ,USER_TELNO)
            VALUES
            ('1','AAA','testA',
			HEX(AES_ENCRYPT('AAA@naver.com', SHA2('[암호화시킬 키값]', 256))),
			HEX(AES_ENCRYPT('010-5444-5678', SHA2('[암호화시킬 키값]', 256))),
			HEX(AES_ENCRYPT('111-222-333-444-555', SHA2('[암호화시킬 키값]', 256))) )
​

복호화 예제)

	SELECT
		USER_ID,
		USER_NM,
		CAST(AES_DECRYPT(UNHEX(USER_CPNO), SHA2('[암호화한 키값]', 256)) AS CHAR) AS USER_CPNO,
		CAST(AES_DECRYPT(UNHEX(USER_EMAD), SHA2('[암호화한 키값]', 256)) AS CHAR) AS USER_EMAD
	FROM TB_SAMPLE