title: MySQL, Concatenate two columns
body: <p>There are two columns in a MySQL table: <code>SUBJECT</code> and <code>YEAR</code>. </p>
  
  <p>I want to generate an alphanumeric unique number which holds the concatenated data from SUBJECT and YEAR.</p>
  
  <p>How can I do this?  Is it possible to use a simple operator like <code>+</code>?</p>