w3resource

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:

Name Description
str A string.

Syntax Diagram:

MySQL UNCOMPRESS() Function - 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()



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://w3resource.com/mysql/encryption-and-compression-functions/uncompress().php