I have a mysql database with 5000 tables. I need to delete those tables with 5 rows or less (delete if table contains <=5 records)

I know how to delete a table:
DROP TABLE IF EXISTS mytable001;

but I don't know how to delete tables "globally".
I'm using phpmyadmin.

Any info appreciated.

This could be done with just a little bit of PHP code, but I don't know of any way to do it with just SQL.

Anybody?

I will try with some PHP code
I think it can't be done just with SQL

Something like:

while not(all tables processed) do
{
process(table)
next table
}

process()
{
if table has <=5 rows : drop table
}

Yep, that's the basic idea. If you need any help, let me know.