title: Limit length of longtext field in SELECT results
body: <p>I'm executing a SELECT query on a table in MySQL using the command-line interface (not a GUI client):</p>
  
  <blockquote>
    <p>SELECT * FROM blog_entry;</p>
  </blockquote>
  
  <p>One of blog_entry's fields is of type 'longtext' and is such a long piece of text that when the result is displayed in my terminal the display of rows takes more than one line. This causes an ugly mess of a display, where columns aren't easily visible. What technique can I use in my SELECT query that would limit the number of characters displayed for each field so that the printed row results don't overflow to new lines?</p>