dynamic removeFirstPrepend
<select id="gcmDAO.selectGcmList" parameterClass="searchVO" resultClass="egovMap">
SELECT
PA_ID, SENDER_ID, APP_NAME, API_KEY, PKG_NAME
FROM GCM
<dynamic prepend=" WHERE ">
<isEqual removeFirstPrepend="true" property="searchCondition" compareValue="0">
<isNotEmpty prepend=" AND " property="searchKeyword">
PA_ID = #searchKeyword#
</isNotEmpty>
</isEqual>
<isEqual removeFirstPrepend="true" property="searchCondition" compareValue="1">
<isNotEmpty prepend=" AND " property="searchKeyword">
SENDER_ID = #searchKeyword#
</isNotEmpty>
</isEqual>
<isEqual removeFirstPrepend="true" property="searchCondition" compareValue="2">
<isNotEmpty prepend=" AND " property="searchKeyword">
APP_NAME LIKE CONCAT('%', #searchKeyword#, '%')
</isNotEmpty>
</isEqual>
<isEqual removeFirstPrepend="true" property="searchCondition" compareValue="3">
<isNotEmpty prepend=" AND " property="searchKeyword">
API_KEY LIKE CONCAT('%', #searchKeyword#, '%')
</isNotEmpty>
</isEqual>
<isEqual removeFirstPrepend="true" property="searchCondition" compareValue="4">
<isNotEmpty prepend=" AND " property="searchKeyword">
PKG_NAME LIKE CONCAT('%', #searchKeyword#, '%')
</isNotEmpty>
</isEqual>
</dynamic>
ORDER BY PA_ID DESC
LIMIT #firstIndex#, #recordCountPerPage#
</select>