MyBatis Like 검색 구문
1. Like 구문
1) Oracle
1
column like '%' || #{keyword} || '%'
2) PostgreSQL, MySQL
1
column like CONCAT('%', #{keyword}, '%')
3) MS-SQL
1
title like '%' + #{keyword} + '%'
[출처 및 참고]
This post is licensed under CC BY 4.0 by the author.