my question is that currently if i want to query for multiple wildcarded values. I need to do something like this.

```
select customername from customers where customername like '%smith' or customername like '%potter' or customer name like '%harris' or customername like '%williams';

```

So I wanna ask from the experts, is there any easier way to do this?

Regards,
Sanjan