MySql: find out which tables contain a certain column

To search for a column 'rank' in a database 'mydb':

select * From INFORMATION_SCHEMA.COLUMNS Where column_name like '%rank%' and TABLE_SCHEMA = "mydb"