I have a select statement and I need to find a way to apply a filter to it:
select * from my_table where my_table.field_1 like :filter_item
The real problem is that filter_item can be a string, a string that includes '%' or a comma-separated string that can include wildcard like this:
abc, abgf%fri, e%ij%fd, abcd
The best way would be to solve this without creating any special package/function, etc. But if there is no other way then any solution is welcome.