<!--Oracle--><select id= "Searchuserbysearchname" parametertype= "java.lang.String" resulttype= " Com.urm.entity.User ">select * from T_user where user_name like CONCAT ('% ', #{search_name}, '% ') </select><!- -or--><select id= "Searchuserbysearchname" parametertype= "java.lang.String" resulttype= "Com.urm.entity.User" >select * from T_user where user_name like '% ' | | #{search_name}| | ' % ' </select><!--mysql--><select id= "searchuserbysearchname" parametertype= "java.lang.String" Resulttype= "Com.urm.entity.User" >select * from T_user where user_name like CONCAT ('% ', #{search_name}, '% ') </ select><!--SQL Server--><select id= "Searchuserbysearchname" parametertype= "java.lang.String" Resulttype= "Com.urm.entity.User" >select * from T_user where user_name like '% ' +#{search_name}+ '% ' </select> <!--DB2--><select id= "Searchuserbysearchname" parametertype= "java.lang.String" resulttype= " Com.urm.entity.User ">select * from T_user wheRe user_name like CONCAT ('% ', #{search_name}, '% ') </select><!--or--><select id= " Searchuserbysearchname "parametertype=" java.lang.String "resulttype=" Com.urm.entity.User ">select * from T_user Where user_name like '% ' | | #{search_name}| | ' % ' </select>
Like fuzzy queries for Oracle, MySQL, DB2, SQL Server in MyBatis