-
==================================================
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},'%')
'Database' 카테고리의 다른 글
SQL Statement Log 를 보기위한 log4jdbc 사용법 (2) 2016.03.24 SQLite AUTO_INCREMENT (0) 2016.03.22 MySQL 계정생성 및 권한주기 (0) 2015.12.23 댓글
like절.docx