title: MySQL SELECT AS combine two columns into one
body: <p>Using <a href="https://stackoverflow.com/questions/16062825/combine-two-columns-in-one-column">this solution</a>, I tried to use COALESCE as part of a MySQL query that outputs to a csv file using SELECT As to name the column names when exporting the data.</p>
  
  <pre><code>SELECT FirstName AS First_Name
       , LastName AS Last_Name
       , ContactPhoneAreaCode1
       , ContactPhoneNumber1
       , COALESCE(ContactPhoneAreaCode1, ContactPhoneNumber1) AS Contact_Phone 
    FROM TABLE1
  </code></pre>
  
  <p>I wanted 3 columns: First_Name, Last_Name and Contact_Phone</p>
  
  <p>I am getting 5 columns: First_Name, Last_Name, ContactPhoneAreaCode1, ContactPhoneNumber1 and Contact_Phone</p>
  
  <p>How do I hide the merging of ContactPhoneAreaCode1, ContactPhoneNumber1 into a single column for Contact_Phone from within the query?</p>