SQL查询逗号分割的字段

需求就是，这样一个表里，查询NOTICE_QX含有03的数据。不用LIKE。

 

方案有2种：

1、ORACLE:

SELECT *

  FROM (SELECT N.NOTICE_UUID,

              N.NOTICE_RELEASETIME,

              N.NOTICE_TITLE,

              REGEXP_SUBSTR(N.NOTICE_QX, '[^,]+', 1, LEVEL) QX

          FROM PZ_NOTICE_INFO N

        CONNECT BY LEVEL <= REGEXP_COUNT(NOTICE_QX, ',') + 1

              AND NOTICE_UUID = PRIOR NOTICE_UUID

              AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL

              )

WHERE QX = '03';

2、MySQL

SELECT * FROM 
PZ_NOTICE_INFO
WHERE FIND_IN_SET(‘03’,NOTICE_QX)

 

使用时，请关注查询效率。