sql - Match substring with list members in Big Query -

sql - Match substring with list members in Big Query -

is there way in big query utilize contains list of words, instead of 1 word @ time in fashion below:

select page_title, if (page_title contains (select sourcename sourcetypes),1,0) visitors

how using equivalent join?

select word [publicdata:samples.shakespeare] cross bring together (select split(fragments) fragment (select "duck,cat,bear" fragments)) b word contains fragment grouping 1 word ---- bear scathful bearing dedication mollification ...

replace "(select split...)" desired "(select sourcename sourcetypes)".

sql google-bigquery