MyBatis - [ 쿼리문 where like ]

1. MySql

<select id="getMemberList" resultType="MemberVO">
    select id, name
    from bcc_member 
    where id like concat('%', #{id}, '%')
</select>

 

 

 

 

 

---

참조

https://dongram.tistory.com/12

[MyBatis] 동적 쿼리 LIKE 문 삽질 주의