title: mysql select all table names except
body: <p>Alright, I know you can do the following to get all column names.</p>
  
  <pre><code>SHOW COLUMNS FROM person;
  </code></pre>
  
  <p>However, it does not allow where statements.</p>
  
  <p>Is there any way to get the full list and just say not this one?</p>
  
  <p>So I am basically looking for something like this:</p>
  
  <pre><code>select (show columns from person where Field &lt;&gt; 'id') from person
  </code></pre>