mySQL – Search column name in all tables

src – https://takeinproject.wordpress.com/2014/04/23/how-to-search-for-a-specific-column-name-in-all-the-tables-in-mysql-workbench/

SELECT
table_name,
column_name,
data_type,
ordinal_position
FROM INFORMATION_SCHEMA.COLUMNS

WHERE table_schema = 'xxxdbase' AND column_name LIKE '%confirm%'

By: |03/12/2019|categories: