mybatis模糊查询sqlserver和mysql的写法

sqlserver写法：

 <select id="queryVehicleRfidInfo" resultMap="BaseResultMap" parameterType="com.tis.entity.VehicleRfidInfo">
      select * from VEHICLE_RFID_INFO where 1=1  
      	<if test="licence!=null and licence!=''">
		    and VEHICLE_RFID_INFO.LICENCE LIKE '%'+#{licence,jdbcType=NVARCHAR}+'%'  
		 </if>
         <if test="vehicleOwner != null and vehicleOwner != ''">
            and VEHICLE_RFID_INFO.VEHICLE_OWNER LIKE '%'+#{vehicleOwner,jdbcType=NVARCHAR}+'%'  
         </if>
  </select>

mysql写法：

 <select id="queryVehicleInfo" resultMap="BaseResultMap" parameterType="com.zit.entity.VehicleInfo">
      select * from vehicle_info where 1=1  
    	<if test="hphm != null and '' != hphm">  
	    <bind name="pattern_hphm" value="'%'+hphm+'%'"/>
                and hphm like #{pattern_hphm}  
	</if>
</select>

或

materialname like concat('%', #{materialname}, '%')