一句简单的SQL----模糊 查询

模糊查询 

   @Select("select  * from u_user u WHERE u.nickname LIKE CONCAT ('%',#{email},'%')" +
            " OR u.email LIKE CONCAT ('%',#{email},'%')")
    List<Uuser> selectAccount(String email);

带分页的模糊查询

 

  /**
     *  模糊查询分页
     * @param email
     * @param index
     * @param currentCount
     * @return
     */
    @Select("SELECT * FROM u_user u WHERE u.nickname LIKE CONCAT ('%',#{email},'%') " +
            "OR u.email LIKE CONCAT ('%',#{email},'%') LIMIT #{index},#{currentCount}")
    List<Uuser>  limitLike(@Param("email") String email,@Param("index") int index,@Param("currentCount") int currentCount);