Mssql 优化模糊查询

最新推荐文章于 2021-06-22 17:47:15 发布

行一米

最新推荐文章于 2021-06-22 17:47:15 发布

阅读量912

点赞数

分类专栏： MSSQL 文章标签：优化 ms sql

本文链接：https://blog.csdn.net/baidu_36415076/article/details/53193055

版权

MSSQL 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

 '01,05,0b,0e' like '%01%' 
 改成
 CHARINDEX('01', '01,05,0b,0e')>0

例子如下：
 SELECT ROW_NUMBER() OVER(ORDER BY OCCUR_DATE, SERIAL_NO) AS REC_NUM,
       SERIAL_NO, FRT_BIZ, CUST_CODE, CUST_NAME, CURR_STATUS, CURR_PHASE, 
       OP_USER, OP_NAME, CUACCT_CODE, INT_ORG,
       OCCUR_DATE, OCCUR_TIME, REMARK
       FROM FRT_BIZ_LOG
       WHERE OCCUR_DATE BETWEEN 20161001 AND 20161003
             AND (CHARINDEX(','+CONVERT(VARCHAR, INT_ORG)+',', ','+'0'+',') > 0 OR '0' IN ('0', '999') )
             AND CHARINDEX(FRT_BIZ, '01,05,0b,0e') > 0