select id,name,user_out_work_no as workCode,user_level_name as userLevelName from crisps_mch_user_info where mch_detail_id = #{mchUserParam.mchDetailId} <if test="mchUserParam.nameWork != null and mchUserParam.nameWork != '' "> AND CONCAT( IFNULL(`NAME`,''),IFNULL(`user_out_work_no`,'')) LIKE CONCAT('%',#{mchUserParam.nameWork},'%') </if>
如上,有时候我们一个输入框,需要模糊匹配多个字段查询,可以使用上面的结构。入参nameWork会模糊匹配姓名或者工号查询