MySQL phpmyadmin - show BLOB to a viewable format

When using phpmyadmin to list out the records from a table, it will display a link for download a bin file if the field format is defined in BLOB.

If you want to display the content directly, you can using the convert function as below:

SELECT CONVERT('field_name' USING utf8) FROM table;