mysql截取字符串

ｓｅｌｅｃｔ LEFT(‘www.yuanrengu.com‘,8)

ｓｅｌｅｃｔ RIGHT(‘www.yuanrengu.com‘,6)

ｓｅｌｅｃｔ SUBSTRING(‘www.yuanrengu.com‘, 9)

ｓｅｌｅｃｔ SUBSTRING(‘www.yuanrengu.com‘, 9, 3)

ｓｅｌｅｃｔ SUBSTRING(‘www.yuanrengu.com‘, -6)

ｓｅｌｅｃｔ SUBSTRING(‘www.yuanrengu.com‘, -6, 2)

ｓｅｌｅｃｔ SUBSTRING_INDEX(‘www.yuanrengu.com‘, ‘.‘, 2);

ｓｅｌｅｃｔ SUBSTRING_INDEX(‘www.yuanrengu.com‘, ‘.‘, -2);

ｓｅｌｅｃｔ SUBSTRING_INDEX(‘www.yuanrengu.com‘, ‘sprite‘, 1);