Mysql select table names

Mysql find tables with name

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

Mysql find tables with column name

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

Source: stackoverflow.com

Mysql select table names

SELECT *
FROM information_schema.tables
WHERE table_type='BASE TABLE'
AND table_schema='<insert_your_database_name_here>'

Source: stackoverflow.com

Similar codes

0 vote111 views1 answer
List in one column mysql
SQL
0 vote117 views2 answers
Reseed sql identity
SQL
2 votes104 views1 answer
Sql column values comma separated
SQL
3 votes108 views3 answers
Stop mysql service ubuntu
SQL
-1 vote103 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote102 views1 answer
Find number of entries sql
SQL
0 vote112 views1 answer
Yesql
SQL
0 vote127 views1 answer
Mssql find deadlocks
SQL
0 vote186 views1 answer
How to use select union and loop
SQL
1 vote113 views2 answers
Intersect sql
SQL