1、left从左开始截取字符串
left(string, length) -- (字符串,截取长度)
示例:
SELECT id,LEFT(id,4) FROM organization
运行结果:
2、right从右开始截取字符串
right(string, length) -- (字符串,截取长度)
示例:
SELECT id,RIGHT(id,4) FROM organization
运行结果:
3、substring截取字符串
substring(string, position, length) --(字符,截取开始位置,长度:不填直接截取到最后)
substring(string, position)
示例:
SELECT path,SUBSTING(path,5,4)FROM organization
SELECT path,SUBSTING(path,5) FROM organization
运行结果:
4、substring_index按关键字截取字符串
substring_index(string,delimiter,count) --(字符,查找的字符,从查找字符的第几次出现开始截取)
示例:
SELECT path,SUBSTRING_INDEX(dath,"/",2) FROM organization
SELECT path,SUBSTRING_INDEX(dath,"/",-2) FROM organization
运行结果: