3. Back-end/3-1. Spring MVC - 국비

MyBatis - [ 쿼리문 where like ]

yunyj99 2022. 6. 29. 10:54

1. MySql

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

 

 

 

 

 

참조