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:
[sql]SELECT CONVERT(my_blob_column USING utf8) AS plain_text_from_blob
FROM my_table;
[/sql]
Yes, these little tricks you need once in a lifetime …