I am attempting to look for patterns in the data using like statements. I do not know where in the text field I will find the pattern, I don't care about the position. How do I get teradata to recognize the difference between like "%click_" and only return rows that have click_ and not return clickstream? Simple example below.
select databasename, tablename from dbc.tables where tablename like '%click_%'