Mybatis中oracle、mysql、db2、sql server的like模糊查询

最新推荐文章于 2023-07-28 01:00:32 发布

最是那一低头的温柔

最新推荐文章于 2023-07-28 01:00:32 发布

阅读量306

点赞数

分类专栏： Mybatis

Mybatis 专栏收录该内容

53 篇文章 0 订阅

订阅专栏

<!-- 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>  
<!-- 或者 -->  
<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>  
<!-- 或者 -->  
<select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">  
  select * from t_user where user_name like '%'||#{search_name}||'%'   
</select>

Mybatis技术学习，更多知识请访问https://www.itkc8.com