Mysql: Find a table by its name

Earlier today I needed to find a table in a mysql database schema of a few hundred tables, i didn’t know the exact name and could only guess what the full name might be

Lo and behold

Just replace {{SCHEMA_NAME}} with your databse schema name

SHOW TABLES WHERE Tables_in_{{SCHEMA_NAME}} LIKE 'something_%';

 

Gareth

Back to Index