字符创截取

    public static void main(String[] args) {
        String str = "http://img.kktijian.com/gr/img/OldImages/http://img.kktijian.com/gr/img/OldImages/JiGou/2017-05-05/304b243d11374cee83cf5386c228a2df.PNG ";
        String substring = str.substring(41);
        System.out.println(substring);
    }

输出结果：

http://img.kktijian.com/gr/img/OldImages/JiGou/2017-05-05/304b243d11374cee83cf5386c228a2df.PNG 

String substring = str.substring(41);

从索引为N的字符开始截取,包含N

 

MYSQL 截取：

UPDATE hsp_hospital SET `intro` = SUBSTRING(`intro`,42) where id = 3088

从第N个字符开始截取,包含N