Count If 조건 넣기

COUNT 안에 IF문을 넣어 CONDITION이 참일때 카운팅

COUNT(IF([CONDITION], [COLUMN], NULL))

 

실제 사용 쿼리

<select id="selectProductCount" resultType="hashMap">
	SELECT count(1) as countAll
    	, count(if(DISPLAY_YN = 'Y', DISPLAY_YN, NULL)) as countY
        , count(if(DISPLAY_YN = 'N', DISPLAY_YN, NULL)) as countN
	FROM TB_COIT_PET_REG_PRDT
	WHERE CATEGORY_ID = #{searchCate}
</select>