extract string in longblob column

[liofr]

Hi
how can i retrieve string value contains in a longblob column ?
i test CAST and CONVERT mysql function but don't work.
Doesn't seem hard but don't see howto do that
select  * FROM table

Thank's for any help