Method 1:

SELECT * FROM `information_schema`.`COLUMNS`
where COLUMN_NAME LIKE "%sdfgsdfg%"
LIMIT 2000;

Method 2

Oracle:

SELECT owner,table_name, column_name
FROM all_tab_columns
WHERE column_name like '%YOUR_COLUMN_NAME%'
AND OWNER in ('YOUR_SCHEMA_NAME'); )