MySQLで暗号化されたデータを復号化する方法になります
SELECT
CONVERT(AES_DECRYPT(UNHEX(last_name), 'base64:**********=') USING utf8)
FROM
users
WHERE
user_id = 10
UNHEX でバイナリに変換。
AES_DECRYPT で復号化。
CONVERT 指定した文字セットに変換
More than 1 year has passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme