title: MySQL drop tables where engine is memory
body: <p>I have a data base where I have permanent versions of tables that I make copies of and then convert to memory engine for faster performance.  Is there a way to delete all the tables in a db by engine type?  Something along the lines of:</p>
  
  <pre><code>drop * from db1 where engine = memory;
  </code></pre>
  
  <p>Any suggestions?</p>