title: mysql add "prefix" to every value in column
body: <p>I need to add a 'prefix' in front of every value in a certain column. </p>
  
  <p>Example: all fields in column x are: 200, 201, 202, 203, etc.
  I need them to be pn_200, pn_201, pn_202, pn_203, etc.</p>
  
  <p>Is there a way to use <code>ALTER</code> or <code>MODIFY</code> commands to do this?</p>
  
  <p>I would like something like <code>ADD to BEGINNING of * column_name 'pn_'</code></p>
  
  <p>Or perhaps a way to do it in <strong>PHP</strong>? Maybe get the value of the field, turn that into a variable, and do something like.</p>
  
  <pre><code>`$variablex = `'SELECT column_name FROM table'
  $result = mysqli_query($con, variablex);
   foreach($r=mysqli_fetch_row($result) {
      `ADD TO BEGINNING OF * column_name 'pn_'`
  </code></pre>
  
  <p>Is there anyway to do that?</p>