I know I'm late to this but the below should work:

SELECT table_name, column_name 
FROM information_schema.columns 
WHERE column_name LIKE '%column_name%';