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

	
<!-- 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在oracle、mysql、db2、sql server的like模糊查询

标签：

本文系统来源：http://www.cnblogs.com/hrhguanli/p/4679816.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！