怎么实现in 后面加上like的效果，选择数据字典biz_dict1表中的biz_desc，和数据字典biz_dict2表中的biz_desc，相似的记录，如“上海”和“中国上海”

怎么实现in 后面加上like的效果，选择数据字典biz_dict1表中的biz_desc，和数据字典biz_dict2表中的biz_desc，相似的记录，如“上海”和“中国上海”

select * from biz_dict t,data_dictionary t1 

where   t.biz_type='REGISTRY_PORT' and t1.data_dictionary_type='船籍港'  and  t.biz_desc like '%'||t1.data_dictionary_desc||'%' ;