Cara menggunakan mysql decrypt

MySQL DES_DECRYPT[] function

DES_DECRYPT[] function

MySQL DES_DECRYPT[] function decrypts an encrypted string and returns the original string.

Syntax:

DES_DECRYPT[crypt_str, [key_str]];

Arguments:

Syntax Diagram:

MySQL Version: 5.6

Example:

Code:

SELECT DES_DECRYPT[DES_ENCRYPT['mytext','mypassward'],'mypassward'];

Explanation:

The above MySQL statement decrypts the encrypted string 'mytext' as specified in the argument and returns the original string.

Sample Output:

mysql> SELECT DES_DECRYPT[DES_ENCRYPT['mytext','mypassward'],'mypassward'];
+--------------------------------------------------------------+
| DES_DECRYPT[DES_ENCRYPT['mytext','mypassward'],'mypassward'] |
+--------------------------------------------------------------+
| mytext                                                       | 
+--------------------------------------------------------------+
1 row in set [0.01 sec]

PHP script:

example-des_decrypt - php mysql examples | w3resource