How to query multiple tables to see if they share a common column?
One possible way is selecting from information_schema.tables and a correlated subquery from information_schema.columns.

SELECT t.table_name `TABLE _NAME`,
       coalesce((SELECT 'TRUE'
                        FROM information_schema.columns c
                        WHERE c.table_schema = t.table_schema
                              AND c.table_name = t.table_name
                              AND c.column_name = '&lt;column&gt;'),
                'FALSE') `HAS COLUMN`
       FROM information_schema.tables t;


And another is conditional aggregation from information_schema.columns.

SELECT table_name `TABLE NAME`,
       CASE
         WHEN count(CASE column_name
                      WHEN '&lt;column&gt;' THEN
                        1
                    END) &gt; 0 THEN
           'TRUE'
         ELSE
           'FALSE'         
       END `HAS COLUMN`
       FROM information_schema.columns
       GROUP BY table_name;