mysql字符串截取命令_MySQL

bitsCN.com

mysql字符串截取命令

 

1. substring_index

substring_index(str,delim,count)
 

[html]    

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)  

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)  
 

bitsCN.com