MariaDB 암호화, 복호화

SET block_encryption_mode = 'aes-256-cbc';
SET @key_str = ENCRYPT_KEY;
SET @init_vector = ENCRYPT_IV;

// 암호화
SELECT TO_BASE64(AES_ENCRYPT(필드, @key_str, @init_vector)) from 테이블;

// 복호화
SELECT AES_DECRYPT(FROM_BASE64(필드), @key_str, @init_vector) from 테이블;