摘要:
下文讲述MySQL数据库中系统函数SUBSTRING_INDEX的功能简介,如下所示;
系统函数SUBSTRING_INDEX功能说明
SUBSTRING_INDEX系同函数功能:
返回字符串中第N个出现分隔符的子串
SUBSTRING_INDEX系统函数语法:
substring_index(str,delim,count)
----------参数说明--------
str:待处理的源字符串
delim:分隔符
count:计数
----------返回值说明----
返回分隔符后的子串
SUBSTRING_INDEX系统函数注意事项:
当count为零时,返回空字符
当count为正数时,返回第count个分隔符左边的所有字符串
当count为负数时,返回从右边数第count个分隔符对应的右边所有字符串
系统函数SUBSTRING_INDEX示例说明
mysql> select substring_index('www.maomao365.com','.',0);
+--------------------------------------------+
| substring_index('www.maomao365.com','.',0) |
+--------------------------------------------+
| |
+--------------------------------------------+
1 row in set (0.00 sec)
mysql> select substring_index('www.maomao365.com','.',1);
+--------------------------------------------+
| substring_index('www.maomao365.com','.',1) |
+--------------------------------------------+
| www |
+--------------------------------------------+
1 row in set (0.00 sec)
mysql> select substring_index('www.maomao365.com','.',2);
+--------------------------------------------+
| substring_index('www.maomao365.com','.',2) |
+--------------------------------------------+
| www.maomao365 |
+--------------------------------------------+
1 row in set (0.00 sec)
mysql> select substring_index('www.maomao365.com','.',3);
+--------------------------------------------+
| substring_index('www.maomao365.com','.',3) |
+--------------------------------------------+
| www.maomao365.com |
+--------------------------------------------+
1 row in set (0.00 sec)
mysql> select substring_index('www.maomao365.com','.',4);
+--------------------------------------------+
| substring_index('www.maomao365.com','.',4) |
+--------------------------------------------+
| www.maomao365.com |
+--------------------------------------------+
1 row in set (0.00 sec)
mysql> select substring_index('www.maomao365.com','.',5);
+--------------------------------------------+
| substring_index('www.maomao365.com','.',5) |
+--------------------------------------------+
| www.maomao365.com |
+--------------------------------------------+
1 row in set (0.00 sec)
mysql> select substring_index('www.maomao365.com','.',-5);
+---------------------------------------------+
| substring_index('www.maomao365.com','.',-5) |
+---------------------------------------------+
| www.maomao365.com |
+---------------------------------------------+
1 row in set (0.00 sec)
mysql> select substring_index('www.maomao365.com','.',-1);
+---------------------------------------------+
| substring_index('www.maomao365.com','.',-1) |
+---------------------------------------------+
| com |
+---------------------------------------------+
1 row in set (0.00 sec)
mysql> select substring_index('www.maomao365.com','.',-2);
+---------------------------------------------+
| substring_index('www.maomao365.com','.',-2) |
+---------------------------------------------+
| maomao365.com |
+---------------------------------------------+
1 row in set (0.00 sec)
mysql> select substring_index('www.maomao365.com','.',-3);
+---------------------------------------------+
| substring_index('www.maomao365.com','.',-3) |
+---------------------------------------------+
| www.maomao365.com |
+---------------------------------------------+
1 row in set (0.00 sec)