How can I check MySQL tables from a database in accordance with particular column/s name?

The following statement shows the list of two tables having a column ‘email’ in Sample database −

mysql> SELECT DISTINCT TABLE_NAME
    -> FROM INFORMATION_SCHEMA.COLUMNS
    -> WHERE COLUMN_NAME IN('EMAIL')
    -> AND TABLE_SCHEMA = 'SAMPLE';
+---------------+
| TABLE_NAME    |
+---------------+
| employee      |
| new_student   |
+---------------+
2 rows in set (0.04 sec)

Manikanth Mani

Published on 19-Feb-2018 07:25:04

• Related Questions & Answers
• How Can I check the size of the tables in a particular MySQL database?
• How can I check the character set of all the tables along with column names in a particular MySQL database?
• Given a column name how can I find which tables in a MySQL database contain that column?
• How can I query for all the tables having a particular column name?
• How can we check the character set of all the tables in a particular MySQL database?
• How to check table status of the tables in a particular MySQL database?
• How can we analyze the tables of a particular database from MySQL Server command line?
• How can I count unique records from a column in MySQL database?
• How can we get the list of tables in a particular database from MySQL Server command line?
• How to find tables with a specific column name in MySQL?
• Merging 2 tables with similar column name SAP HANA database
• How do I select four random tables from a MySQL database having thousands of tables?
• How can I check the tables of databases other than current database?
• Get all the tables from a MySQL database having a specific column, let’s say xyz?
• How can I change the name of an existing column from a MySQL table?