title: MySQL exclude column from select when column is equal to a specfic value
body: <p>I have a Select query that selects columns from a table where there id is a specific value, e.g. </p>
  
  <pre><code>SELECT ID, Col1, Col2 FROM table1 WHERE ID = 4;
  </code></pre>
  
  <p>Where Col2 is an Integer column. If Col2 is 0 I want to exclude it from the select. At least 1 row will be returned by the above.</p>
  
  <p>So basically if Col2 is 0, Return ID and Col1, if it isn't 0, return all three.</p>
  
  <p>Is there any way to do this in MySQL?</p>
  
  <p>EDIT: I should have said exclude the value not the column.</p>