title: MySQL query SELECT a.foo AS bar - Multiple?
body: <p>I have a query which I'm trying to group multiple table columns as "text", have a look at my query:</p>
  
  <pre><code>SELECT a.id as id, 
         a.name AS title, 
         (a.address1, a.address2, a.suburb, a.state, a.pcode) AS text, 
         a.suburb AS suburb
  </code></pre>
  
  <p>I get this error when trying to use it this way:</p>
  
  <blockquote>
    <p>1241 - Operand should contain 1 column(s)</p>
  </blockquote>
  
  <p>Is what I'm trying to do impossible? Is there a work around for this?</p>