mysql字符串截取命令
1. substring_index
substring_index(str,delim,count)
[html] www.2cto.com
mysql> select substring_index('a-b-c-d','-',-1);
+-----------------------------------+
| substring_index('a-b-c-d','-',-1) |
+-----------------------------------+
| d |
+-----------------------------------+
1 row in set (0.00 sec)
mysql> select substring_index('a-b-c-d','-',1);
+----------------------------------+
| substring_index('a-b-c-d','-',1) |
+----------------------------------+
| a |
+----------------------------------+
1 row in set (0.00 sec)
www.2cto.com
2. SUBSTRING
SUBSTRING(str,pos,len)
SUBSTRING(str FROM pos FOR len)
SUBSTRING(str,pos)
SUBSTRING(str FROM pos)
[html]
mysql> select substring((substring_index('a-b-c-d','-',2)),2);
+-------------------------------------------------+
| substring((substring_index('a-b-c-d','-',2)),2) |
+-------------------------------------------------+
| -b |
+-------------------------------------------------+
1 row in set (0.01 sec)
