mysql, how to delete some table

[b1122]

Hi all,
is that possible in mysql (using php), delete all table that have similiar name.
example, i want delete table that have name tab01, tab02, tab03.
just try 'delete from tab**' but is not working.
thanks for any reply

[chazzy]

DROP TABLE `table_name`; is the proper SQL.

[b1122]

I mean with 1 script, delete many table with similiar names.
example, table name begining with abcxxx (abc001, abc002, abc003, ...)

[chazzy]

well..how are you expecting to read in the table names. there is no wild card for something like dropping a table. you can read the table names from a data dictionary (usually in the mysql database under tables, i believe).