MySQL中IN （字串）查詢

標籤：sql in 字串

方法一：

SELECT Z.ZONE_ID,Z.NAME,Z.CODE,Z.OTHER_NAME FROM T_SYS_ZONE Z

WHERE CONCAT(‘,‘(SELECT ZI.INCHARGE_ZONE FROM T_CRM_SALES_INCHARGE_ZONE ZI WHERE Z.SALES_MEN=7)，‘,‘)

方法二：

SELECT Z.ZONE_ID,Z.NAME,Z.CODE,Z.OTHER_NAME FROM T_SYS_ZONE Z

WHERE FIND_IN_SET(Z.ZONE_ID,(SELECT ZI.INCHARGE_ZONE FROM T_CRM_CLES_INCHARGE_ZONE ZI WHERE ZI.SALES_MEN=7))

本文出自 “架構師之路” 部落格，請務必保留此出處http://5934541.blog.51cto.com/5924541/1631345

MySQL中IN （字串）查詢