select * from mw_job where job_name like concat('%',#{name,jdbcType=VARCHAR},'%') order by if(stick_end > now(),stick_end,0) desc,job_refresh_time desc,create_time desc
模糊查询并对结果进行排序 排序方式为:企业最新置顶岗位(有空数据)>企业最新刷新岗位>企业最新发布岗位` select * from mw_job where job_name like concat('%',#{name,jdbcType=VARCHAR},'%') order by if(stick_end > now(),stick_end,0) desc,job_refr