title: Mysql Select 1 column AS
body: <p>I am wanting to select 1 column from my select statement as but then leave the rest as is so:</p>
  
  <pre><code>SELECT tbl_user.reference AS "reference", * FROM tbl_user JOIN tbl_details ON.....
  </code></pre>
  
  <p>Is this possible?</p>