关于模糊查询多个字段的问题

kylinhome

以前我提过一个问题，怎么用一个参数查询数据库的多个字段，问了客服说是没有办法，今天试验了一个笨办法，各位看看是否可取。

SELECT [ID]
   ,[IPAddess]
   ,[EquipmentName]
   ,[ComputerName]
   ,[Remarks]
   ,[InputData]
   ,[Staff]
   ,[Mac]
   FROM dbo.[IT_IP_List]
where 1=1
${if(len(Query)=0,"","and (ISNULL(EquipmentName,'')+ISNULL(ComputerName, '')+ISNULL(Remarks, '')) like '%"+Query+"%'")}

wzh5788 · 发表于 2015-12-8 16:05:53

${if(len(Query)>0,"","and (EquipmentName like '%"+Query+"%'","")}
${if(len(Query)>0,"","or ComputerNamelike '%"+Query+"%'","")}
${if(len(Query)>0,"","or Remarks like '%"+Query+"%')","")}

这样式呢。。。。