Searching all database schemas - how to use wildcards? Using sqlworkBench I'm looking for column names. I'd like to use wild cards in my search using the below query. when I search for column "activated_at" it works but searching with wild card fails, can anyone help ?

SELECT 
    table_schema,
    table_name, 
    column_name, 
    data_type,
    ordinal_position

FROM  INFORMATION_SCHEMA.COLUMNS 

WHERE column_name = 'activated_a*' ;
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 '='