| | | 23.43.1.SUBSTRING_INDEX(str,delim,count): Returns the substring from string str before count occurrences of the delimiter delim |
|
|
If count is positive, everything to the left of the final delimiter is returned. |
If count is negative, everything to the right of the final delimiter is returned. |
SUBSTRING_INDEX() performs a case-sensitive match when searching for delim. |
mysql>
mysql> SELECT SUBSTRING_INDEX('www.java2s.com', '.', 2);
+-------------------------------------------+
| SUBSTRING_INDEX('www.java2s.com', '.', 2) |
+-------------------------------------------+
| www.java2s |
+-------------------------------------------+
1 row in set (0.00 sec)
mysql>
|
|
|