[MyBatis] LIKE 검색 구문 (Oracle, PostgreSQL, MySQL, Mssql)

[PostgreSQL] [MySQL] 

AND title LIKE CONCAT('%', #{search01}, '%')

[Oracle] 

AND title LIKE '%' || #{search01} || '%'

[Mssql]

AND title LIKE '%' + #{search01} + '%'

 

 

 

 

 

출처 :  https://fruitdev.tistory.com/60