in reply to Best Perlish way to test if a mysql table exists?

my %tables; $tables{$_} = scalar( @{$dbh->selectcol_arrayref("SHOW TABLES LIKE +'$_'")} ) foreach ( @tables_to_query );
will result in the %tables hash having either a 1 or 0 for whether or not each table in @tables_to_query exists.