내용 |
ORACLE LIKE 절
- ibatis
WHERE(AND) column LIKE '%'||#search_value#||'%'
- mybatis
WHERE(AND) coumn LIKE '%'||#{search_value}||'%'
MS-SQL LIKE 절
- ibatis
WHERE(AND) column LIKE '%'+#search_value#+'%'
- mybatis
WHERE(AND) column LIKE '%'+#{search_value}+'%'
MySQL LIKE절
- ibatis
WHERE(AND) column LIKE CONCAT('%',#search_value#,'%')
- mybatis
WHERE(AND) column LIKE CONCAT('%',#{search_value},'%')
|