[SQL] myBatis 동적 SQL 문자열 비교

        <select id="getProductList" parameterType="hashmap" resultMap="productResultSet">
            SELECT *
            FROM PRODUCT
            JOIN GOODS_CATEGORY ON (CATENAME = PRODUCT_CATEONE)
            WHERE CATECODE = #{no}
            <if test="what eq '인기순'.toString()">
                ORDER BY PRODUCT_COUNT DESC
            </if>
            <if test="what eq '가격순'.toString()">
                ORDER BY PRODUCT_PRICE
            </if>
        </select>