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>=#2025-8-22# ) )  and PriceOfOurStation>=480 and (GoodsName like '%鎽勫奀椀庤ã€%' or Introduce like '%鎽勫奀椀庤ã€%' or GoodsBriefIntroduction like '%鎽勫奀椀庤ã€%' or GoodsCode like '%鎽勫奀椀庤ã€%') Order By  Preface ,ID Desc<br />Sql³ö´í£ºÄÚ´æÒç³ö<br />²éѯÊý¾ÝµÄʱºò·¢ÏÖ´íÎó£¬Çë¼ì²éÄúµÄ²éѯ´úÂëÊÇ·ñÕýÈ·¡£