mysql select tables code example
Example 1: mysql find tables with name
SELECT table_name
FROM information_schema.tables
WHERE table_type = 'base table' AND table_name like '%YOUR TABLE NAME%';
Example 2: select tables from mysql database
SHOW TABLES from <databasename>;
Example 3: show tables mysql
Press CTRL+C to copy SHOW [EXTENDED] [FULL] TABLES
[{FROM | IN} db_name]
[LIKE 'pattern' | WHERE expr]