title: Insert results from concatenated statement in a MySQL table
body: <p>Given two fields in a table, how can I use the results of a <code>CONCAT</code> query to populate the results of a third column in the same table?</p>
  
  <pre><code>SELECT CONCAT (`field`, '-', `field2`) from `bgt_table` 
  </code></pre>
  
  <p>prints out the correct format, but how can I insert the results in the appropriate row?</p>