mysql - search for a column name inside the whole database -

mysql - search for a column name inside the whole database -

how search whole database column name in sqli.

suppose have 160 tables many columns want animals column within database. how that. have seen couple of examples here search column name if table name known. if dont know table itself..??

table 1, table 2..... table 160 , looking "animal" column in whole database.

i tried if table known working

select * table_name column_name='animal'

query select table_name information_schema.columns column_name='animal';

read information_schema here

mysql sql