title: How can I "select *" from a table in MySQL but omit certain columns?
body: <p>I have a table with the following columns:</p>
  
  <pre><code>id,name,age,surname,lastname,catgory,active
  </code></pre>
  
  <p>Instead of: <code>SELECT name,age,surname,lastname,catgory FROM table</code></p>
  
  <p>How can I make something like this: <code>SELECT * FROM table [but not select id,active]</code></p>