Sometimes it can be useful to have the content of MySQL blob columns displayed as plain text. There’s a pretty easy way to do this:
SELECT CONVERT(my_blob_column USING utf8) AS plain_text_from_blob FROM my_table;
Yes, these little tricks you need once in a lifetime …