How do I convert from BLOB to TEXT in MySQL?

Question

I have a whole lot of records where the text has been stored in a blob in MySQL. For ease of handling, I'd like to change the format in the database to TEXT... Any ideas on how easy to make the change so as not to interrupt the data - I guess it will need to be encoded properly?

Answer 1

You can use the code this way: 

SELECT CONVERT(column USING utf8) FROM table_name

Instead of using the below code:

SELECT column FROM table_name;

To master SQL statements, queries and become proficient in SQL queries, enroll in our industry-recognized SQL course.