Open In App

MySQL | DES_DECRYPT ( ) Function

Improve
Improve
Like Article
Like
Save
Share
Report

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.

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 

Last Updated : 13 Nov, 2019
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads