模糊查询，条件查询

<select id="selectByOuterJobTitle" resultMap="BaseResultMap">
		select id,ad_id,job_title,job_category_names,working_place,publish_date
        from t_beisen_position_ad
        where data_status = 1 and channel_id = 4 and status = 1
		<if test="jobTitle != null and jobTitle != ''">
			<bind name="jobTitle" value="'%' + jobTitle + '%'" />
			and job_title like #{jobTitle, jdbcType=VARCHAR}
		</if>
		<if test="jobCategoryNames != null and jobCategoryNames != ''">
			and job_category_names = #{jobCategoryNames, jdbcType=VARCHAR}
		</if>

		<if test="workingPlace != null and workingPlace != ''">
            <bind name="workingPlace" value="'%' + workingPlace + '%'" />
            and working_place like #{workingPlace, jdbcType=VARCHAR}
		</if>
		<if test="categoryDescription != null and categoryDescription != ''">
			and category_description =#{categoryDescription, jdbcType=VARCHAR}
		</if>
		<if test="jobadIshot != null and jobadIshot != ''">
			and jobad_ishot =#{jobadIshot, jdbcType=VARCHAR}
		</if>
		<if test="practiceType != null and practiceType != ''">
			and practice_type =#{practiceType, jdbcType=VARCHAR}
		</if>
       order by publish_date desc
	</select>