UNCOMPRESS

Syntax

UNCOMPRESS(str)

Description

Decompresses a string that was compressed by the COMPRESS() function.

Examples

SELECT UNCOMPRESS(COMPRESS('abc'));
+-----------------------------+
| UNCOMPRESS(COMPRESS('abc')) |
+-----------------------------+
| abc                         |
+-----------------------------+
1 row in set (0.001 sec)