title: String truncate on length, but no chopping up of words allowed
body: <p>I want to limit a string field length in MYSQL on a certain length, but I don't want any chopping up of words to occur.</p>
  
  <p>When I do:</p>
  
  <pre><code>SELECT SUBSTRING('Business Analist met focus op wet- en regelgeving', 1, 28)
  </code></pre>
  
  <p>I get this as output:</p>
  
  <pre><code>Business Analist met focus o
  </code></pre>
  
  <p>But I would like</p>
  
  <pre><code>Business Analist met focus
  </code></pre>
  
  <p>How can I enforce a limit of 28 chars, but prevent chopping up words? Off course it's easy in [insert programming language of choice here] ;-), but I want to know if it's possible in MYSQL in a simple statement.</p>