Post

MyBatis Like 검색 구문

Posted Updated
By dejavuhyo
1 min read
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} + '%'

[출처 및 참고]

Framework, MyBatis
mybatis-like-syntax mybatis-like mybatis-like-검색 mybatis-like-검색-구문
This post is licensed under CC BY 4.0 by the author.