mysql
<select id="findOldFileName" parameterType="java.lang.String" resultType="java.lang.String">
select old_file_name
from t_file
<where>
<if test="oldFileName != null and oldFileName != '' ">
old_file_name like concat('%',#{oldFileName},'%')
</if>
</where>
</select>
Oracle
<select id="findOldFileName" parameterType="java.lang.String" resultType="java.lang.String">
select old_file_name
from t_file
<where>
<if test="oldFileName != null and oldFileName != '' ">
old_file_name like concat(concat('%',#{custName}),'%')
</if>
</where>
</select>