I just started working on a large project with hundreds of tables. I want to see all of the tables relating to DNS. I can't remember all of the table names that I'm working with, but I know they have "dns" in the name.
Is it possible to query the list of tables in a database and return just the names? It would be like
SHOW TABLES FROM <database> WHERE table_name LIKE '%dns%';
You can use the information_schema database;
WHERE table_schema = <database>
AND table_name LIKE '%dns%'