title: MySQL concatenate a string to a column
body: <p>What I'm trying to do its edit the information from a row adding more data, for example:</p>
  
  <pre><code>select name, obs from users where area='it'
  </code></pre>
  
  <p>It gives me:</p>
  
  <pre><code>name       obs
  charles    vegetarian
  xena       otaku
  </code></pre>
  
  <p>and I want to add to the their obs 'friendly hard worker'</p>
  
  <p>I have tried:</p>
  
  <pre><code>update users set obs=obs+' frienly hard worker' where area='it'
  </code></pre>
  
  <p>but it didn't work, the result that I want is:</p>
  
  <pre><code>name       obs
  charles    vegetarian frienly hard worker
  xena       otaku frienly hard worker
  </code></pre>