title: Merging result from 2 columns with same name and not over-writing one
body: <p>I have a simple MySQL query like:</p>
  
  <pre><code>SELECT * 
    FROM `content_category` CC , `content_item` CI 
   WHERE CI.content_id = '" . (int)$contentId . "'
     AND CI.category_id = CC.category_id
     AND CI.active  = 1
  </code></pre>
  
  <p>Both tables have a column called <code>configuration</code> one of which gets overwritten in the query i.e only content_item.configuration is returned in the result.</p>
  
  <p>Short of implicitly naming and aliasing the columns like</p>
  
  <pre><code>SELECT CC.configuration as `category_configuration`,
         CC.category_id as `.....
  </code></pre>
  
  <p>is there a way of selecting ALL data i.e * from both and resolve those duplicate column names in a non-destructive way. </p>