mybatis模糊查询mysql模糊查询
@Select("<script> " +
"select * from job a \n" +
"left join job_type b on a.job_id = b.job_type_id\n" +
"where a.delete_flag=0 and a.status=1 and \n" +
"<if test = \"jobName !=null \" >\n" +
" a.job_name like concat(concat('%',#{jobName,jdbcType=VARCHAR},'%')) " +
"</if>\n" +
"\n" +
"<if test = \"jobTypeName !=null