Drop multiple tables with same prefix

[hsriat]

How can I drop all the tables from the database which start with a common prefix (say t1_)?

Query or PHP code... any simple solution?

[mwasif]

You can drop tables like this. But you can select all tables starting with t1 with the following query
[CODE=mysql]SHOW TABLES LIKE 't1%'[/CODE]

Use this query in PHP to get all the table and loop through them to drop one table at a time.

[hsriat]

Thank You mwasif... this worked good and saved my time. :)

[mwasif]

You are welcome.