How to uncompress (restore) compressed data using the UNCOMPRESS() function?

UNCOMPRESS(str) is a MySQL built-in function that uncompresses a given compressed byte string using the default LZ77 compression algorithm. For example:

SELECT UNCOMPRESS(x'37000000789C738BF44C4ECD2B492DD24BCECFD57123960700279D13DD');
  -- +---------------------------------------------------------------------------+
  -- | UNCOMPRESS(x'37000000789C738BF44C4ECD2B492DD24BCECFD57123960700279D13DD') |
  -- +---------------------------------------------------------------------------+
  -- | FYIcenter.com,FYIcenter.com,FYIcenter.com,FYIcenter.com                   |
  -- +---------------------------------------------------------------------------+

Reference information of the UNCOMPRESS() function:

UNCOMPRESS(bin): str
  Uncompresses a given compressed byte string using the default LZ77 
  compression algorithm.

Arguments, return value and availability:
  bin: Required. The byte string to be uncompressed.
  str: Return value. The uncompressed byte string.
  Available since MySQL 4.1.

Related MySQL functions:

• COMPRESS() - Compressing Data
• UNCOMPRESS() - Uncompressing Data
• UNCOMPRESSED_LENGTH() - Uncompressed Data Length

⇒ UNCOMPRESSED_LENGTH() - Uncompressed Data Length

⇐ STATEMENT_DIGEST_TEXT() - Calculating Statement Digest

⇑ MySQL Functions for Encryption and Compression

⇑⇑ MySQL Function References