title: How to wrap (prefix & suffix) all values in a column with a string?
body: <p>I have a MySQL table with about 1000 rows in it.</p>
  
  <pre><code>id column
  1  apple
  2  banana
  ...
  etc
  </code></pre>
  
  <p>I need a MySQL query (UpdatE) to wrap (prefix &amp; suffix) all values in a column with a specific string, let's say "_", so I am expecting a result:</p>
  
  <pre><code>id column
  1  _apple_
  2  _banana_
  ...
  etc
  </code></pre>
  
  <p>How to do that? Please, advice.</p>