title: MySQL select fields containing leading or trailing whitespace
body: <p>I can use the MySQL <code>TRIM()</code> method to cleanup fields containing leading or trailing whitespace with an <code>UPDATE</code> like so:</p>
  
  <pre><code>UPDATE Foo SET field = TRIM(field);
  </code></pre>
  
  <p>I would like to actually see the fields this will impact before this is run. I tried this but returns 0 results:</p>
  
  <pre><code>SELECT * FROM Foo WHERE field != TRIM(field);
  </code></pre>
  
  <p>Seems like this should work but it does not.</p>
  
  <p>Anyone have a solution? Also, curious why this does not work...</p>