DES_DECRYPT()
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Decrypts a string using the DES algorithm with the given key.
EXAMPLES
CREATE TABLE t1 (a CHAR(240), b BIT(48));
INSERT INTO t1 VALUES
('a',b'0001'), ('b',b'0010'), ('c',b'0011'), ('d',b'0100'),
('e',b'0001'), ('f',b'0101'), ('g',b'0110'), ('h',b'0111'),
('i',b'1000'), ('j',b'1001');
SELECT DES_DECRYPT(a, 'x'), HEX(b) FROM t1;
+---------------------+--------+
| DES_DECRYPT(a, 'x') | HEX(b) |
+---------------------+--------+
| a | 1 |
| b | 2 |
| c | 3 |
| d | 4 |
| e | 1 |
| f | 5 |
| g | 6 |
| h | 7 |
| i | 8 |
| j | 9 |
+---------------------+--------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.