<select id="queryPro" resultType="com.EnforceReportProblemParam">
SELECT
*
FROM enforce_report_problem
where action_id = #{param.WhistleId}
//
<if test="param.keyWord!=null and param.keyWord!=''">
AND (
problem_code like concat('%',#{param.keyWord},'%')
or problem_source_name like concat('%',#{param.keyWord},'%')
)
</if>
</select>
模糊key搜索
最新推荐文章于 2024-10-01 18:51:18 发布