DECODE

Syntax

DECODE(crypt_str,pass_str)

Description

DECODE() uses pass_str as the password to decrypt the encrypted string crypt_str and returns the decrypted string.

Examples

SELECT DECODE(ENCODE('secret','cry'), 'cry');
+---------------------------------------+
| DECODE(ENCODE('secret','cry'), 'cry') |
+---------------------------------------+
| secret                                |
+---------------------------------------+
1 row in set (0.001 sec)