SELECT TABLE_NAME, COLUMN_NAME from columns WHERE... (a value exists)

Experts:

I have millions of tables to search through for a word (i.e., cotton) but I don't know which table the word is located in and I don't know what the column name will be for any given table.  Is there a way to search all tables, all columns where in any of the columns the word exists?

Thanks in advance for your help