Spring) gradle, mybatis mapper.xml 에서 like 쿼리시 주의점

1. Oracle 11g xe : project[EMP]

- build.gradle

dependencies {
  implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.1.4'
  runtimeOnly 'com.oracle.database.jdbc:ojdbc8'
}

- application.properties

spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:xe
spring.datasource.username=scott
spring.datasource.password=tiger

- EmpMapper.xml

<mapper namespace="com.devtory.emp.dao.EmpDao">
  <select id="empList" resultType="com.devtory.emp.vo.Emp" parameterType="com.devtory.emp.vo.Emp">
    select * from emp where ename like '%'||#{ename}||'%' and job like '%'||#{job}||'%'
  </select>
</mapper>

2. MySql 5.5 : project[gusto]

- build.gradle

dependencies {
  implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.1.4'
  runtimeOnly 'mysql:mysql-connector-java'
}

- application.properties

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/gusto?serverTimezone=Asia/Seoul&characterEncoding=UTF-8
spring.datasource.username=userid
spring.datasource.password=userpw

- BlogMapper.xml

<mapper namespace="com.devtory.emp.dao.EmpDao">
  <select id="empList" resultType="com.devtory.emp.vo.Emp" parameterType="com.devtory.emp.vo.Emp">
    select * from blog
    where title like CONCAT('%', #{title}, '%')
        and short_description like CONCAT('%', #short_description}, %')
  </select>
</mapper>