Deleting Databases

[lord_robert]

I made a table structure (or hirachy) like this:

                ja_1

ja_1_1 ja_1_2

ja_1_1_1 ja_1_2_1 ...... 3 layers

Now I got problems if I want to drop all
the tables that contain the ja_1.

Is there any command that I can somehow use to drop
all the tables in my database that contain ja_1???

Thanks, Robert.

[ZibingsCoder]

Do you mean you want to drop all tables that start with ja_1*? As in, anything from ja_1 to...say, ja_1_30958_293_929?

[lord_robert]

Yes, that's exactly what I mean.