如果它包含另一个字段（在参考表中）中存在的某个字符串，则更新tableA中的字段？

I am trying to standardise col_value(field) if it contains the string that is present in reference table. The valid_value will be replaced with invalid and the whole string will be updated to updated_col_value in TableA.I am trying to standardise col_value(field) if