Mysql find all tables with column names which contain specific word

Sometimes it can be important to find all tables with column names which contain specific word. We can do that with next query:

SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name LIKE '%word%';
sources of information
source visit date
how-to-find-all-the-tables-in-mysql-with-specific-column-names-in-them 2015.06.12