用upper()函数的执行效率比like 高:当它找到第一个匹配时就不会在向下执行,但 like 会,所以使用 upper();
例:
<dynamic prepend="AND">
<isNotEmpty prepend="AND" property="mouTeamName">
instr(upper(MOU_TEAM_NAME), upper(#mouTeamName:VARCHAR#)) > 0
</isNotEmpty>
<isNotEmpty prepend="AND" property="mouTeamDesp">
instr(upper(MOU_TEAM_DESP),upper(#mouTeamDesp:VARCHAR#))>0
</isNotEmpty>
</dynamic>
例:
<dynamic prepend="AND">
<isNotEmpty prepend="AND" property="mouTeamName">
instr(upper(MOU_TEAM_NAME), upper(#mouTeamName:VARCHAR#)) > 0
</isNotEmpty>
<isNotEmpty prepend="AND" property="mouTeamDesp">
instr(upper(MOU_TEAM_DESP),upper(#mouTeamDesp:VARCHAR#))>0
</isNotEmpty>
</dynamic>