title: MySQL combine two columns into one column
body: <p>I'm trying to find a way to combine two columns into one, but keep getting the value '0' in the column instead to the combination of the words.</p>
  
  <p>These are what I've tried as well as others:</p>
  
  <pre><code>SELECT column1 + column2 AS column3
  FROM table;
  
  SELECT column1 || column2 AS column3
  FROM table;
  
  SELECT column1 + ' ' + column2 AS column3
  FROM table;
  </code></pre>
  
  <p>Could someone please let me know what I'm doing wrong?</p>