MySQL in a Nutshell

Name

UNCOMPRESS( )

Synopsis

UNCOMPRESS(string)

This function returns uncompressed string. It reverses the results of the COMPRESS( ) function. It requires MySQL to have been compiled with a compression library (i.e., zlib), and it returns NULL if the string is not compressed or if MySQL wasn’t compiled with zlib.

SELECT UNCOMPRESS(essay)
FROM applications_archive
WHERE applicant_id = '1748';