模糊查询

sql语句

<select id="selectBymh" resultType="house" parameterType="house">
    select * from t_house
    <where>
        <if test="houseNum!=null and houseNum!=''">
            and houseNum like concat(concat('%',#{houseNum},'%'))
        </if>
        <if test="houseName!=null and houseName!=''">
            and houseName like concat(concat('%',#{houseName},'%'))
        </if>
    </where>
    order by houseNum asc
</select>