Multiple strings in LIKE condition - Presto SQL

user_9473729 0
Viewed 6875

I want to query a column in my table using a LIKE condition and this works fine-

select * from my_table where my_column LIKE '%hello%';

But, how do I query this column with multiple strings in my LIKE condition? Looking for something like-

select * from my_table where my_column LIKE ['%hello%'|'example%'|'%random%'|'%demo'];
presto sql
1 Answers

Use regexp_like():

select *
from my_table
where regexp_like(my_column, 'hello|example|random|demo');
user_11440350
Related