Filter by "Contains" with multiple values

Hi,

I know that the question filter "Contains" in the GUI is using the LIKE operator for PostgreSQL which checks the substring.
Is it possible to filter by multiple values using "Contains"?
i.e. col1 LIKE '%str1%' OR col1 LIKE '%str2%' OR col1 LIKE '%str3%'
If no, will passing filter variable to a raw SQL be capable of doing this?

1 Like

Hi @llg3888
You would have to either use Custom Expressions https://www.metabase.com/docs/latest/questions/query-builder/expressions or a SQL Text variable https://www.metabase.com/learn/sql-questions/sql-variables#basic-input-variable-text