title: Selecting all fields except only one field in mysql
body: <blockquote>
    <p><strong>Possible duplicate:</strong><br>
    <a href="https://stackoverflow.com/q/9122/3578036">Select all columns except one in MySQL?</a></p>
  </blockquote>
  
  <p>I want to know is there a way to select all fields except one field from a table in my database.</p>
  
  <p>I know I can describe the field names in the select query.<br>
  For example:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT fieldname1, fieldname2, fieldname3, fieldname4 FROM tablename;
  </code></pre>
  
  <p>But my question is, is there any way to do it in a simple way... Like this</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM tablename EXCEPT(fieldname3);
  </code></pre>
  
  <p>I am using MySQL and Zend framework.</p>