Question

SQL语句多条件模糊查询中 为空的字段怎么让他忽略掉 在线等

我现在遇到的问题就是 一个多条件的模糊查询,每个条件里面都写才查得到结果~ 用的LIKE'%"&key&"%'的模糊查询,我试过填所有的信息,包括模糊查询都有结果,但是如果某个条件为空就查不到~sql ="select broker_org_name from broker_org where broker_org_name like '%"&key&"%' or broker_person like '%"&key&"%'or broker_prove_num like '%"&key&"%' or broker_licence like '%"&key&"%' or broker_operation_type like '%"&key&"%' or broker_enroll_address like '%"&key&"%'"KEY是变量~ 会的大虾麻烦解决下~在线等!

Answer 1

select distinct t.编号 from ((select 编号,公司,单号,订单号,日期,null as 物品名称,null as 规格,null as 数量,null as 单价 from a)union all(select 表头,null,null,null,null,物品名称,规格,数量,单价 from b))t where t.公司 like '%变量%' ~

Answer 2

select broker_org_name from broker_org where (broker_org_name like '%"&key&"%' and broker_org_name is not null) or (broker_person like '%"&key&"%' and broker_person is not null)