How to drop all tables with prefix bak_

Question

Would this find and drop all tables with the given prefix?

DROP TABLE IF EXISTS 'bak_'

There are other tables with "mmp_hdkji" that I do not want to drop.

possible duplicate of [Drop all tables whose names begin with a certain string](http://stackoverflow.com/questions/4393/drop-all-tables-whose-names-begin-with-a-certain-string) — The Blue Dog, Mar 06 '14 at 09:13

score 0 · Answer 1 · answered Mar 07 '14 at 14:48

Since you're using phpMyAdmin, if PeteR's answer isn't to your liking, you can shift-click to select many tables at once.

From the database structure page, you can click the checkbox in front of each table you want. If, as in your case, there are a number that are ordered one after the other, click the top one then shift-click the bottom one. The ones in between will also be selected. Once you have all your tables selected, click the "With selected:" dropdown and go to "Drop".

The simple solutions are not always obvious. Thanks. – modernmagic Mar 07 '14 at 18:37 — modernmagic, Mar 07 '14 at 18:37

How to drop all tables with prefix bak_

1 Answers1