Delete multiple tables in MySQL

[mindrage]

I cannot figure this one out.. seems rather simple enough. I want to delete multiple rows of tables that CMS system created. How do I delete multiple rows?

I am using MySQL Control Center and the client doesnt seem to allow that. Anyway I could do it using SQL commands?

[cherria]

I assume you know which rows you want to delete, you don't give enough details so I'll make some up.

if you're table is called tab1 and you have a column (field) called cond1 which could have numeric values and you wanted to delete all the rows where cond1 had the value 33 then the SQL would be:

DELETE from tab1 where cond1=33

If its more complicated than that, post back details and we'll take it from there.

[HalfaBee]

Try mysql-front it can do it.

You will have to try google for the download page.

HalfaBee

[mindrage]

I think I'll try downloading MySQL-Front and see if it would do what I need.

Cherria, is there a command to delete all tables starting with PHP?? Or lets say tables from Row 1-22?

Scott