Oracle多关键字查询

t.defect_phenomenon, t.defect_code, t.voltage_level from sp_pd_Defect t where (regexp_like(t.defect_phenomenon, ‘(杆塔|鸟巢)+‘) or regexp_like(t.defect_code, ‘(杆塔|鸟巢)+‘) or regexp_like(t.voltage_level, ‘(杆塔|鸟巢)+‘));  如图：

如需要查询的关键字为“杆塔 鸟巢 110000”

select t.defect_phenomenon, t.defect_code, t.voltage_level
from sp_pd_Defect t
where (regexp_like(t.defect_phenomenon, ‘(杆塔|鸟巢|110000)+‘) or
regexp_like(t.defect_code, ‘(杆塔|鸟巢|110000)+‘) or
regexp_like(t.voltage_level, ‘(杆塔|鸟巢|110000)+‘));

 如图：

 

Oracle多关键字查询

标签：.com   where   使用   原理   关键字查询   like   regexp   之间   条件