Mysql TRIM not working
<p>I'm trying to cleanse my numbers in my database by using :</p>

<pre><code>update valuations set Telephone = TRIM(Telephone) where  1 = 1
</code></pre>

<p>but 0 rows are effected and all the nunmbers still have a space in them. The datatype is varchar so im unsure why this isn't working - can anyone help?</p>

<p>Thanks</p>