#57 Spring Boot Mybatis SELECT 조건, MyBatis LIKE 사용

 2019.08.01

 

 

검색 화면

 

<select id="searchMember" parameterType="String" resultType="kr.or.ksmart.ksmart_layout1.vo.Member">
        SELECT 
              m_id        AS memberId
            , m_pw        AS memberPw
            , m_level    AS memberLevel
            , m_name    AS memberName    
            , m_email    AS memberEmail
        FROM tb_member 
        <if test="sv neq null and sv neq ''.toString()">
            WHERE
                ${sk} LIKE CONCAT('%',#{sv},'%')
        </if>
</select>

 

 // 오늘의 에러

 Mybatis 쿼리문에서 부등호 사용시 나오는 에러

 The content of elements must consist of well-formed character data or markup

 부등호를 <![CDATA[부등호]]> 형식으로 바꿔줘야한다

 

▼