med = ['acyclovir' ,'azathioprine' ,'basiliximab' ,'bevacizumab' ,'carboplatin','ciprofloxacin_dexamethasone_oticAND med IN ('acyclovir' ,'azathioprine' ,'basiliximab' ,'bevacizumab' ,'carbop
我试过下面的方法,但不起作用case when lower(drug) like ('%cortisol%','%cortisone%','%dexamethasoneUNNEST(table_1.drug) drug
WHERE REGEXP_CONTAINS( db.Team01.Table_1.drug,r'%cortisol%','%cortisone%','%dexamethasone