title: MySQL truncate text with ellipsis
body: <p>Suppose I have a MySQL table of one column: "Message". It is of type TEXT.
  I now want to query all rows, but the text can be large (not extremely large but large) and I only want to get a summary of them. For example the result can be populated into a list.</p>
  
  <p>Is there a way to trim the text to a specific length (say, 10 characters), and add ellipsis if the text is trimmed?</p>
  
  <p>For example:</p>
  
  <pre><code>Message
  -----------
  12345678901234
  1234567890
  12345
  12345678901
  </code></pre>
  
  <p>Query result:</p>
  
  <pre><code>1234567...
  1234567890
  12345
  1234567...
  </code></pre>
  
  <p>Thanks!</p>