Q:

MySQL, search a database and tell what tables contain two specific columns?

I have a database with well over 90 tables and I am trying to figure which, if any, of them have the same two specific columns.  The code I am looking for would be something like this:
SHOW TABLES IN `database` 
      WHERE column = 'columnA' 
        AND column = 'columnB';`

Is this even possible?  

A:

This will give you all tables having either of the two columns, which you can browse through to find what you need.
  select *
    from information_schema.columns
   where column_name in ('columnA', 'columnB')
order by table_name, column_Name

