DB
[MyBatis] LIKE 검색 구문 (Oracle, PostgreSQL, MySQL, Mssql)
natrue
2021. 12. 28. 14:33
728x90
[PostgreSQL] [MySQL]
AND title LIKE CONCAT('%', #{search01}, '%')[Oracle]
AND title LIKE '%' || #{search01} || '%'[Mssql]
AND title LIKE '%' + #{search01} + '%'