Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

MySQL | DES_DECRYPT ( ) Function

  • Last Updated : 13 Nov, 2019

The MySQL DES_DECRYPT function is used for decrypting an encrypted string using DES(Data Encryption Standard) algorithm. The MySQL DES_DECRYPT function uses a key to decrypt a string.

The value returned by the DES_DECRYPT function is a decrypted string or NULL. The DES_DECRYPT function accepts two parameters which are the encrypted string and a key string to decrypt the string.

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

Syntax:

DES_DECRYPT(encrypted_string, key_string);

Parameters Used:



  • encrypted_string – It is used to specify an encrypted string which is to be decrypted.
  • key_string – It is used to specify a key which is used to decrypt the encrypted string.

Return Value:
The DES_DECRYPT function in MySQL returns a decrypted string.

Supported Versions of MySQL:

  • MySQL 5.7
  • MySQL 5.6
  • MySQL 5.5
  • MySQL 5.1
  • MySQL 5.0
  • MySQL 4.1

Example-1: Implementing DES_DECRYPT function on a string.

SELECT  
AES_DECRYPT(AES_ENCRYPT('ABC', 'key_string'), 'key_string'); 

Output:

ABC 

Example-2: Implementing AES_DECRYPT function on a string with a combination of characters and integer values.

SELECT  
AES_DECRYPT(AES_ENCRYPT('ABC123', 'key_string'), 'key_string'); 

Output:

ABC123 

Example-3: Implementing AES_DECRYPT function on a bigger string.

SELECT  
AES_DECRYPT(AES_ENCRYPT('Geeksforgeeks', 'key_string'), 'key_string'); 

Output:

Geeksforgeeks 

Example-4: Implementing AES_DECRYPT function on a NULL string.

SELECT  
AES_DECRYPT(AES_ENCRYPT(NULL, 'key_string'), 'key_string'); 

Output:

NULL 
My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!