title: MySQL: Ignore a selected column when using DISTINCT
body: <p>Let's say:</p>
  
  <ol>
  <li><p>I want to query colA, colB and colC in my table.</p></li>
  <li><p>I want to see DISTINCT values but I don't want colA to be a criteria for distinction.</p></li>
  <li><p>Omitting colA isn't an option.</p></li>
  </ol>
  
  <p>What's the best way to structure that query?</p>