MySQL Workbench - view all contents of a MEDIUMTEXT column?

Question

This is admittedly a simple question, I just don't have a background in MySQL to find out about this, and google search was fruitless. I have a MySQL table with several columns of middle text. When I run a SELECT query using the MySQL Workbench, it only shows a truncated version of the content. How can I see the entire contents of a mediumtext column in a workbench? I am sure this is just a configuration setting that I am missing.

Answer 1

• SQL Query Preference → Max. The length of the field to display . The default is 256 bytes;
• Right-click on the cell with MEDIUMTEXT in the results pane and select "Open Value in Editor";
• Query menu → Run (All or selection) to text;