title: How to drop all tables that contain a certain string?
body: <p>I need to drop tables that start with "my_database.test_table5 . . . " </p>
  
  <p>how can I do this? </p>
  
  <pre><code>DROP TABLE * 
  WHERE tablename IN 
  (
  SEL tablename 
  FROM dbc.tables 
  WHERE tablename like '%test_table5%' 
  AND databasename = 'my_database' 
  ) 
  </code></pre>