Drop Several Tables at Once

Question

I have some tables that I need to drop on a regular basis. The names of the tables sometimes change but the table names always begin with 'db_comp_temp'. Is it possible to write some SQL that will in effect do something like:

DROP TABLE db_comp_temp* 

Thanks in advance,