How do I convert from BLOB to TEXT in MySQL?

That’s unnecessary. Just use SELECT CONVERT(column USING utf8) FROM…..