Searching all database schemas - how to use wildcards?
You can try this:

SELECT table_schema, table_name, column_name, data_type, ordinal_position
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name LIKE 'activated_a%' ;


When you want to use wildcard, you have to use LIKE instead of '='