LIKE 사용법

오라클은 

like '%'||#value#||'%' 

Mysql은 

like concat('%','#value#','%') 

Sysbase, SQL SERVER

like '%' + #value# + '%'

예제)

<![CDATA[

SELECT COUNT(*) AS CNT 

FROM 

aaaaaa A, 

bbbbbbbb B 

WHERE A.aaa = B.bbb

]]>

<isNotEmpty property="searchKeyword" prepend=" AND ">

$searchCondition$ LIKE CONCAT('%',#searchKeyword#,'%')

</isNotEmpty> 

<![CDATA[

SELECT * FROM (

SELECT 

aaaaa

bbbbbbbbb

FROM 

aaaaaaaaaaaaaaa A, 

bbbbbbbbbbbbbbb B 

WHERE 

A.aaaa = B.bbbb 

ORDER BY aaaa DESC

)Z

WHERE 1=1

]]>  

<isNotEmpty property="searchKeyword" prepend=" AND ">

$searchCondition$ LIKE CONCAT('%',#searchKeyword#,'%')

</isNotEmpty>

<![CDATA[  

ORDER BY aaaaaa DESC LIMIT #firstIndex#, #recordCountPerPage#

]]>