title: mysql - adding/concatenating text values within a SELECT clause
body: <p>Is there a way in MySQL to concatenate text to values using a SELECT statement? (like in Oracle)</p>
  
  <p>For example, in Oracle you can write something like this:</p>
  
  <pre><code>SQL&gt; select 'The Year is '|| year, 'The month is '|| month from time where rownum &lt; 2;
  
  'THEYEARIS'||YEAR
  ----------------------------------------------------
  'THEMONTHIS'||MONTH
  -----------------------------------------------------
  The Year is 2009
  The month is 1
  </code></pre>