Knowledge Walls
John Peter
Pune, Maharashtra, India
AES_ENCRYPT() and AES_DECRYPT() Method in Mysql with Example
21933 Views
AES_ENCRYPT 
AES_ENCRYPT method is used to encrypt the given string with key using AES(Advanced Encryption Standard) Algorithm.

Syntax
AES_ENCRYPT(data, key);

Example
SELECT AES_ENCRYPT("God is Great","yahooo");
AES_DECRYPT 
AES_DECRYPT method is used to decrypt the given encrypted data of AES_ENCRYPT method with key using AES(Advanced Encryption Standard) Algorithm.

Syntax
AES_DECRYPT(aes_encrypted data, key);

Example
SELECT AES_DECRYPT(AES_ENCRYPT("God is Great","yahooo"),"yahooo");
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details