mysql中处理字符串时,默认第一个字符下标为1 。
【1】从左开始截取字符串
left(str, length)
说明:left(被截取字段,截取长度)
select left('15993729750',6) from dual;
- 1
【2】从右开始截取字符串
right(str, length)
说明:right(被截取字段,截取长度)
select right('15993729750',6) from dual;
- 1
【3】截取字符串
substr(str, pos)
与SUBSTR(str FROM pos)功能一致
- 1
substr(str, pos, length)
与SUBSTR(str FROM pos FOR len)功能一致
- 1
说明:substr(被截取字段,从第几位开始截取)
substr(被截取字段,从第几位开始截取,截取长度)
select substr('15993729750',5) from dual;
- 1
select substr('15993729750',5,3) from dual;
- 1
(注:如果位数是负数 如-5 则是从后倒数位数,到字符串结束或截取的长度)
select substr('15993729750',-5,3) from dual;
- 1
select substr('15993729750',-5) from dual;
- 1
【4】按关键字截取字符串
substring_index(str,delim,count)
说明:substring_index(被截取字段,关键字,关键字出现的次数)
select SUBSTRING_INDEX('1599372123456','3','2') from dual;
- 1