模糊查询

mysql版本

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

oracle版本

<if test="deviceFactoryName != null and deviceFactoryName != ''">
    AND DEVICE_FACTORY_NAME LIKE concat('%',#{deviceFactoryName},'%')
</if>