title: MySQL - Excluding Rows From SELECT
body: <p>I have been given a Table with ~50 columns. Obviously I could select them all with:-</p>
  
  <pre><code>SELECT * FROM...
  </code></pre>
  
  <p>However for confidentiality  three columns must not be selected. Many of the columns use long identifiers. Is there a way of selecting all columns by excluding nominated ones rather than selecting all ~47?</p>