LIKE CONCAT(CONCAT('%',#{post_title},'%'))

实例 dao层

    @Select("select b.user_name,c.posts_category_name,a.* from posts a LEFT JOIN user b on a.post_author=b.id  LEFT JOIN posts_category c on c.id=a.post_category  where a.status!=1 and a.post_title like CONCAT(CONCAT('%',#{post_title},'%'))")
public IPage<Map<String, Object>> neQueryPageList(Page page,String post_title);