Display content of blob column as plain text

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 …