SQL:select ID,GoodsBriefIntroduction,GoodsGive,GoodsDeduct,GoodsName from [lodo_Goods] where (GoodsLookOverAuthority='All' Or (GoodsLookOverAuthority='nouser' And 0=0) Or (GoodsLookOverAuthority='AllUser' And 0<>0) Or ( GoodsLookOverAuthority<>'All' And GoodsLookOverAuthority<>'AllUser' And GoodsLookOverAuthority<>'nouser' And (Not GoodsLookOverAuthority like '%,0,%') And (0<>0))) and goodsType<>'|0|0|0|0|0|' and Issueno=1 and (AutomaticLowerShelfno=0 or ( AutomaticLowerShelfno=1 and ExpiryDate>=#2024-11-10# ) )  and (GoodsName like '%閸欏秴鍘滈å�?%' or Introduce like '%閸欏秴鍘滈å�?%' or GoodsBriefIntroduction like '%閸欏秴鍘滈å�?%' or GoodsCode like '%閸欏秴鍘滈å�?%') Order By  Preface ,ID Desc<br />Sql�������ڴ����<br />��ѯ���ݵ�ʱ���ִ����������IJ�ѯ�����Ƿ���ȷ��