Mybatis Like Fuzzy Query Function

1.　 Parameters directly include %%

　　param.setUsername("%CD%");
  param.setPassword("%11%");
 <select id="selectPersons" resultType="person" parameterType="person">
 select id,sex,age,username,password from person where true 
 <if test="username!=null"> AND username LIKE #{username}</if>
 <if test="password!=null">AND password LIKE #{password}</if>
 </select>

2. bind tag

<select id="selectPersons" resultType="person" parameterType="person">
 <bind name="pattern" value="'%' + _parameter.username + '%'" />
 select id,sex,age,username,password 
 from person
 where username LIKE #{pattern}
</select>

3. CONCAT

where username LIKE concat(concat('%', #{username}), '%')

　The above is the like fuzzy query function in Mybatis introduced by the editor for everyone. I hope it will be helpful to everyone. If you have any questions, please leave a message, and the editor will reply to everyone in time. Here, I also want to express my sincere gratitude to everyone for their support of the Yell Tutorial website!

Declaration: The content of this article is from the Internet, and the copyright belongs to the original author. The content is contributed and uploaded by Internet users spontaneously. This website does not own the copyright, has not been manually edited, and does not assume any relevant legal responsibility. If you find any content suspected of copyright infringement, please send an email to: notice#w3Please report via email to codebox.com (replace # with @ when sending an email), and provide relevant evidence. Once verified, this site will immediately delete the infringing content.