Write a SELECT that includes the following text:
SHOW TABLES FROM <databaseName>;
This will present you with a list of the MySQL data dictionary type tables in your database, you can then also add a ‘WHERE’ or ‘LIKE’ command to the SQL above in order to filter the results.
How do I get a list of my MySQL tables?