How to select specific table in sql?

Question

Possible Duplicate:
How to find all the tables in MySQL with specific column names in them?

I want to select tables from sql where the table has a column named "TimeStamp". How do I list all the tables where those tables that will be selected has a column named "TimeStamp" in it? I am using MySQL.

Is there a particular reason you need to do this? Could you not use a static `array()` that contains the proper tables in it? — David, Sep 08 '12 at 23:46
You can use [`INFORMATION_SCHEMA`](http://dev.mysql.com/doc/refman/5.5/en/information-schema.html) — ypercubeᵀᴹ, Sep 08 '12 at 23:47

score 4 · Accepted Answer · edited May 23 '17 at 11:49

4

SELECT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME = 'timestamp'
      AND TABLE_SCHEMA='YourDatabase';

Done and done.

Source

edited May 23 '17 at 11:49

Community

1
1

answered Sep 08 '12 at 23:47

David

3,831
2
28
38

How to select specific table in sql?

1 Answers1