mysql SUBSTRING 字符截取函数[网站编程]

substring(str,pos)语法

substring(filed,m):截取filed字段从第m个字符开始到完毕的字符串;

substring(filed,m,n):截取filed字段从第m个字符开始的长度为n的字符串;

str,字符

pos,从第几个开始取

下面看个实例

mysql> select substring('quadratically',5);
-> 'ratically'
mysql> select substring('foobarbar' from 4);
-> 'barbar'
mysql> select substring('quadratically',5,6);
-> 'ratica'
mysql> select substring('sakila', -3);
-> 'ila'
mysql> select substring('sakila', -5, 3);
-> 'aki'
mysql> select substring('sakila' from -4 for 2);
-> 'ki'