How can I find all the tables in MySQL with specific column names in them?

```
select distinct table_name
from information_schema.columns
where column_name in ('ColumnA')
and table_schema='YourDatabase';
and table_name in
(
select distinct table_name
from information_schema.columns
where column_name in ('ColumnB')
and table_schema='YourDatabase';
);
```

That ^^ will get the tables with ColumnA *and* ColumnB instead of ColumnA *or* ColumnB like the accepted answer

In older MySQL versions or some MySQL NDB Cluster versions that do not have `information_schema`, you can dump the table structure and search the column manually.

mysqldump -h$host -u$user -p$pass --compact --no-data --all-databases > some_file.sql

Now search the column name in `some_file.sql` using your preferred text editor, or use some nifty [AWK][1] scripts.

----------

And a simple [sed][2] script to find the column. Just replace *COLUMN_NAME* with yours:

sed -n '/^USE/{h};/^CREATE/{H;x;s/\nCREATE.*\n/\n/;x};/COLUMN_NAME/{x;p};' <some_file.sql
USE `DATABASE_NAME`;
CREATE TABLE `TABLE_NAME` (
`COLUMN_NAME` varchar(10) NOT NULL,

You can pipe the dump directly in sed, but that's trivial.

[1]:

[To see links please register here]

[2]:

[To see links please register here]