regexp_like search all strings

  Hello,

I have a question about regexp_like function.

It is possible to use "or" operator (pipe) to search multiple strings in a string, like this:

select id from my_table where regexp_like(streetname,'york|new','i');

But as said before, this is OR operator.

Is there any way to use "and" operator, so the query would return only rows that contain ALL strings?

It is possilbe to use "and" operator in the where clause, like this:

select id from my_table where regexp_like(streetname,'york','i') and regexp_like(streetname,'new','i');

but this is not what I really want, because: