sqlServer里的Like后跟多个不同条件的查询咋办。。。

Question

--如下sql语句、模糊查询Tree时从一个符合条件的集合中查询

select *  from [3d_Customer_Cymb]  where Cus_Id=101 and Mark=0

      and Tree like 

      (select '%'+cast(Tree as nvarchar(max))+'%' from [3d_Customer_Cymb] 
      
      where Id in 

           ( select Id from [3d_Customer_Cymb] where Mark=0  and  Cus_Id=101 and 
             ParentId=0 )

       and ParentId=0 ) 

order by Sort asc,Id asc

--like后面查询的集合就报错了、咋办

--或者有其他的办法么？

Answer 1

--本人已解决、但是是靠外部代码拼接实现的、

--大体思想是先把那个需要 like 出来的条件集合用 DataTable 存入、然后循环输出并拼接条件

DataTable tab= DbClass.GetList(" select '%'+cast(Tree as nvarchar(max))+'%' as newTree from [3d_Customer_Cymb] where Id in ( select Id from [3d_Customer_Cymb] where Mark=0  and  Cus_Id=101 and ParentId=0 )and ParentId=0 ");

foreach( DataRow item in tab )
{
strWhere = " or Tree Like item["newTree"] ";
}

--还有一个问题就是循环只能添加出 or Tree Like xxx 但第一个 like 是不能有 or 的、

--所以鄙人想出了一个方法、就是先给它 Like 一个不可能查出的条件、再拼接sql

  sql="select *  from [3d_Customer_Cymb]  where Cus_Id=101 and Mark=0 and Tree like '%特朗普是美国总统么？%' "+strWhere+" ";