web developer

[myBatis/SQL] LIKE + CONCAT / DBMS별 sql문 본문

Persistence Framework/iBatis, MyBatis

[myBatis/SQL] LIKE + CONCAT / DBMS별 sql문

trueman 2022. 3. 2. 23:06
728x90
728x90

MySQL

SELECT * FROM TABLE_NAME
WHERE COLUMN_NAME LIKE CONCAT(‘%’, #{Keyword}, ‘%’)

Oracle

SELECT * FROM TABLE_NAME
WHERE COLUMN_NAME LIKE '%'||#Keyword#||'%'

Ms-Sql

SELECT * FROM TABLE_NAME
WHERE COLUMN_NAME LIKE '%' + #Keyword# + '%'

출처 : https://dongram.tistory.com/12

728x90
728x90
저작자표시 변경금지

'Persistence Framework > iBatis, MyBatis' 카테고리의 다른 글

[iBatis] ParameterClass가 String일 경우 isNotEmpty property 설정여부  (2) 2022.04.21
[iBatis] EgovMap, resultClass, parameterClass 정의와 예시  (0) 2022.02.09
[ibatis/Mybatis] ibatis/Mybatis에서 #{}, ${} 차이  (0) 2022.01.05
'Persistence Framework/iBatis, MyBatis' Related Articles more