迂回实现like in 如下: select * from proj_baseinfo p where p.customername like 'xxx' or p.customername like 'yyy'; end;