MySQL UNCOMPRESS() function

UNCOMPRESS() function

MySQL uncompress() brings a compressed string back to its original condition. For compression, compress() function is used.

Syntax:

UNCOMPRESS(str)

Argument:

Syntax Diagram:

MySQL Version: 8.0

Example:

Code:

SELECT UNCOMPRESS(COMPRESS('w3resource'));

Explanation:

The above MySQL statement returns w3resource.

Output:

mysql> SELECT UNCOMPRESS(COMPRESS('w3resource'));
+------------------------------------+
| UNCOMPRESS(COMPRESS('w3resource')) |
+------------------------------------+
| w3resource                         | 
+------------------------------------+
1 row in set (0.00 sec)

Previous: SHA1()
Next: UNCOMPRESSED_LENGTH()