select tables from mysql database
snippet in sql

mysql find tables with name

user3247

SELECT table_name 
FROM information_schema.tables 
WHERE table_type = 'base table' AND table_name like '%YOUR TABLE NAME%';

select tables from mysql database

user5165

SHOW TABLES from <databasename>;

mysql command show tables

user5843

SHOW TABLES;

mysql show tables in database

user515

show tables;

select tables from mysql database

user6434

SHOW TABLES from <databasename>;