title: Mysql:Trim all fields in database
body: <pre><code>UPDATE mytable SET mycolumn= LTRIM(RTRIM(mycolumn));
  </code></pre>
  
  <p>works fine on trimming columns removing trailer spaces, but how can i adjust it to trim all columns <strong>without having to write each column name</strong> in table ?? cause i kind have a huge database.</p>