Mybatis like 查询纪要

       	 	<if test="uiStatus != null and uiStatus != ''">
				AND UI_STATUS = #{uiStatus}
   	  	 	</if>
       	 	<if test="moduleCode != null and moduleCode != ''">
				<!-- AND MODULE_CODE LIKE '%${moduleCode}%' -->
				<!-- AND MODULE_CODE LIKE CONCAT(CONCAT('%',#{moduleCode}),'%') -->
				<!-- AND MODULE_CODE LIKE CONCAT(CONCAT("%","${moduleCode}"),"%") -->
				<!-- AND MODULE_CODE LIKE '%'||#{moduleCode}||'%' -->
-- and activity_no like concat('%', #{ query.activityNo }, '%')
-- and activity_no like concat(#{ query.activityNo }, '%')
				 <bind name="KEY" value="'%'+moduleCode+'%'"/>
				 AND MODULE_CODE LIKE #{KEY}
   	  	 	</if>