title: How do I modify/append a table row using MYSQL?
body: <p>What I know is that you can append values from a query using concat function in MYSQL. </p>
  
  <pre><code>&gt;col1 = ben
  
  UPDATE table set col1 = concat(col1, ' altered')
  
  &gt;col1 = ben altered
  </code></pre>
  
  <p>But what I am trying to achieve is to append anywhere on the col.</p>
  
  <pre><code>col1 = ben
  
  UPDATE table set col1 = "altered " + col1
  -- pseudo code
  
  col1 = altered ben
  </code></pre>
  
  <p>Is there a function for this in mysql?</p>