I was stumbling about the same issue und found the solution here.

In my case I wanted to extract a substring from the BLOB and export it as CSV with MySQL Workbench.

This one did the trick for me.

SELECT CONVERT(SUBSTRING(addData,61 , 24) USING utf8) FROM jobs_dump.jobs where type = 98