SUBSTRING_INDEX(str,delim,count): Returns the substring from string str before count occurrences of the delimiter delim : SUBSTRING_INDEX « String Functions « MySQL Tutorial






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>








23.43.SUBSTRING_INDEX
23.43.1.SUBSTRING_INDEX(str,delim,count): Returns the substring from string str before count occurrences of the delimiter delim
23.43.2.SUBSTRING_INDEX('www.java2s.com', '.', -2);