title: MySQL bulk drop table where table like?
body: <pre><code>DROP TABLE (
  SELECT table_name
  FROM information_schema.`TABLES`
  WHERE table_schema = 'myDatabase' AND table_name LIKE BINARY 'del%');
  </code></pre>
  
  <p>I know this doesn't work! What is the equivalent for something like this in SQL? I can whip out a simple Python script to do this but was just wondering if we can do something with SQL directly. I am using MySQL. Thank you!</p>