多个字段查询结果组合
<select id="getHistoryProblem" parameterType="java.lang.String" resultType="java.lang.String">
select problem_description from construction_quality where problem_description like concat('%',#{str},'%')
union
select rect_condition from construction_quality where rect_condition like concat('%',#{str},'%')
union
select problem_desc from construction_safety where problem_desc like concat('%',#{str},'%')
union
select requirement from construction_safety where requirement like concat('%',#{str},'%')
</select>