SQL Script to find, and drop, tables on a Multisite

Hi everyone.

I help run a WordPress multisite for a College. There are a few hundred sites.

At one point I installed https://wordpress.org/plugins/broken-link-checker/. Works great except when you are done using it there are hundreds of tables in the database. I’m estimating that I can shave about 70MB off of the existing 300MB database if I can remove all of these tables.

So, there is the question – Does anyone know of an sql script that I use that will automatically find tables that include ‘_blc_’ in the name and will automatically drop that table?

Thanks in advance!