title: SQL UPDATE all values in a field with appended string CONCAT not working
body: <p>Here is what I want to do:  </p>
  
  <p>current table:  </p>
  
  <pre><code>+----+-------------+  
  | id | data        |  
  +----+-------------+  
  |  1 | max         |  
  |  2 | linda       |  
  |  3 | sam         |  
  |  4 | henry       |  
  +----+-------------+  
  </code></pre>
  
  <p>Mystery Query ( something like <code>"UPDATE table SET data = CONCAT(data, 'a')"</code> )</p>
  
  <p>resulting table:  </p>
  
  <pre><code>+----+-------------+  
  | id | data        |  
  +----+-------------+  
  |  1 | maxa        |  
  |  2 | lindaa      |  
  |  3 | sama        |  
  |  4 | henrya      |  
  +----+-------------+  
  </code></pre>
  
  <p>thats it! I just need to do it in a single query, but can't seem to find a way. I am using mySQL on bluehost (I think its version 4.1)</p>
  
  <p>Thanks everyone.</p>