728x90
LIKE + % 문자열 검색
Mybatis에서는 DBMS 종류 별로 차이가 있다.
MySql / MariaDB
SELECT * FROM TABLE_NAME
WHERE COLUMN_NAME LIKE CONCAT(‘%’, #{searchKeyword}, ‘%’)
ORACLE
SELECT * FROM TABLE_NAME
WHERE COLUMN_NAME LIKE '%'||#searchKeyword#||'%'
Ms-Sql
SELECT * FROM TABLE_NAME
WHERE COLUMN_NAME LIKE '%' + #searchKeyword# + '%'
출처: https://dongram.tistory.com/12 [오늘은 룡:티스토리]
728x90