title: MySQL query - Add string before, after existing data
body: <p>I was wondering if someone is able to lend some wisdom about how to accomplish the following task in MySQL.  </p>
  
  <p>I need to run a query to add something inside a field before and after the existing data.  For example, let's say I have the following data in 'characters.name':</p>
  
  <pre><code>'Fred Flintstone'
  'Barney Rubble'
  </code></pre>
  
  <p>How would I insert something, in this example 'xxxxx' before the existing data 'Fred Flinstone' and also 'yyyyy' after the data?</p>
  
  <p>The result would be:</p>
  
  <pre><code>'xxxxxFred Flintstoneyyyyy'
  'xxxxxBarney Rubbleyyyyy'
  </code></pre>
  
  <p>Any assistance with this would be greatly appreciated.</p>
  
  <p>Many thanks!</p>