Search column name in a mysql db

SELECT
table_name,
column_name,
data_type,
ordinal_position

FROM INFORMATION_SCHEMA.COLUMNS

WHERE table_schema = 'mydb'
AND column_name LIKE '%pattern%' ;