模糊查询 要用 $符号

  <if test=" search !=null and search !='' ">
	                                  
	          AND CONCAT(
					IFNULL(zsci.clean_name,''),						
					IFNULL(zsci.clean_standard,''),						
					IFNULL(zsci.clean_tool,''),						
					IFNULL(zsci.clean_action,'')
				) 
				LIKE CONCAT('%',#{search},'%')
	    
	     </if> 

   concat（） 方法   # 号 模糊查询

<if test="name!=null and name!=''">
 and t_employee.name   like concat('%',#{name},'%')


</if>

<p>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</p>

<pre>
<code class="language-xml">&lt;select id="selectlikesnames" parameterType="user" resultType="user"&gt;
		select * from employee
		&lt;where&gt;
			&lt;if test="empname!=null and empname!='' "&gt;
				and empname like '%${empname}%'
			&lt;/if&gt;
			&lt;if test="salary!=null and salary!='' "&gt;
			    and salary &gt; ${salary}
			&lt;/if&gt;
		&lt;/where&gt;
	&lt;select&gt;
</code></pre>

<p>&nbsp;</p>

转载于:https://my.oschina.net/u/3566463/blog/1039928