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

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