1 min read
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:
[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 …