Display content of blob column as plain text
Reading Time: < 1 minute 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, Read More …