src - https://takeinproject.wordpress.com/2014/04/23/how-to-search-for-a-specific-column-name-in-all-the-tables-in-mysql-workbench/
1
2
3
4
5
6
7
8
SELECT
table_name,
column_name,
data_type,
ordinal_position
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = 'xxxdbase' AND column_name LIKE '%confirm%'
origin - https://www.pipiscrew.com/?p=16196 mysql-search-column-name-in-all-tables