How to drop several tables with wild card?

Databases
1

drop table like ‘jos%’;

is not working. You would think this would be easy but I can’t find any referance to dropping several tables at once.

Please help.

2

likely because there isn’t any

you could generate the DROP statements by running a query agains the INFORMATION_SCHEMA

i notice you did not post in the mysql forum – what database system are you using?

3

I’m using mySQL 5.1.34 GPL

I actually found the following:

DROP table where table like ‘jos_%’;

which worked sortof - it seemed to freeze the database and I had to go out and go back in but - it worked -those tables were gone.

Thanks,
Diana