title: How to remove tabs at start and end of varchar field in MySQL?
body: <p>I've got a field in a mysql db that's a varchar(255).  I've looked at trim() to remove leading and trailing whitespace, but it seems to only handle spaces, not tab characters:</p>
  
  <pre><code> UPDATE mytable SET textfield = TRIM(textfield);
  </code></pre>
  
  <p>Does anyone know how to also strip tabs off the start and end of a field?</p>