Is it possible to "drop tableS" in mysqlc?

[William BC Crandall]

I've read the manual; I've searched the index of Paul's book;
I've put Google on the trail; all without success.

I have a database with many tables. I would like to drop several
of the tables with wild cards. None of the obvious techniques
work and several online queries such as this have come to a
dead end.

How can I do this:

mysql> DROP TABLE test%;

where % matches zero or more characters?

This syntax does not work for version 4.0.18-max-debug.

Thanks,

-BC